If you are having difficulties when working with the Interactive Dashboard and SData provider within an Oracle install it maybe that the wrong port is being used by the JDBC connection.

JDBC is used for the SData provider and Interactive Dashboard features.

The connection properties are defined in the jdbc.properties file found in:

C:\Program Files\Sage\CRM\CRM70\tomcat\webapps\crm70j\WEB-INF

You may need to check that the file is port 1521 for Oracle rather than port 1433 for SQL Server.