Oracle reference This document is provided to be used as a reference when using Oracle with i2 iBridge Designer Known problems and restrictionsThe following are known problems or restrictions when using Oracle with iBridge:Installing a typical TCP/IP setupBefore you can connect to an Oracle database within iBridge you must install and run the Net Configuration Assistant software on each client computer. The Net Configuration Assistant creates or modifies the file tnsnames.ora, this contains the connection information for any Oracle servers, and is normally located in the folder oracle\admin. Installing the Oracle 9i/10g clientEach computer that uses iBridge to connect to an Oracle database server needs various Oracle client components as well as iBridge. If you do not need the Oracle components for any application apart from iBridge, you may want to minimize the size of the Oracle client install.Connecting to an Oracle databaseWhen the Oracle client software is installed and configured on the client computer you can connect to your Oracle database: Oracle data type mappingsThe table below shows a list of supported Oracle field data types for Microsoft OLE DB Provider for Oracle and Oracle OLE DB Provider for Oracle and how they are mapped via ActiveX Data Object (ADO) types through iBridge to Analyst’s Notebook.
