Answer:
OCI is preferred over ODBC only when the source database system is Oracle since OCI stands for Oracle Call Interface and is a native driver for Oracle database connections. You can go for an ODBC connection for the same as well because ODBC stands for Open Database Connectivity.
Since OCI is a native driver for Oracle, using an OCI connection over ODBC improves performance while connecting to an Oracle datasource from OBIEE RPD. OCI also provides access to many native database features otherwise not accessible from ODBC.
Question: Is an OCI connection preferred when connecting to a Database other than Oracle?
Answer:
No. It is not possible. Since OCI is a native driver to connect to Oracle Datasource it can't be used to connect to data sources other than Oracle.
Links to read more:
- http://twobiee.blogspot.in/2012/10/odbc-or-oci.html
- http://obieemanu.blogspot.in/2011/01/odbc-vs-oci.html
No comments:
Post a Comment