This content has been marked as final. Show 3 replies
OCI is simialr to an ODBC connection but is faster to retreve data from an Oracle database since you are going through a more native connection
Oracle Call Interface (OCI) is an alternative to ODBC to significantly improve data load and dimension build performance. With this method, you use Data Prep Editor in EAS console to specify
an OCI connect identifier.
To use an Oracle OCI connect identifier, use the following syntax for the Data Source Name (DSN) identification:
Following is an example OCI connect identifier where the host server name is “myserver,” the port number is 1521, and the Oracle Service Name is “orcl”:
It is faster though it is full fo bugs so if you are going to use it I would recommend moving to the latest patches.