Connecting to an Oracle database

When the Oracle client software is installed and configured on the client computer you can connect to your Oracle database:

  1. In i2 iBridge Designer, select New from the File menu to display the Provider page of the Data Link Properties dialog.
  2. Select Microsoft OLE DB Provider for Oracle from the list of OLE DB providers and click Next to display the Connection page of the Data Link Properties dialog.
  3. Enter the Net Server name. This is the same as the name you entered in the Oracle Net Configuration Assistant.
  4. You need only enter the logon information into this dialog if you want to test the connections. However, the analysts will be required to specify a username and password when connecting to the database from within i2 Analyst’s Notebook.
    If you do not want the analysts to be prompted for a username and password, turn on the Allow saving password check box. This has security implications because the username and password are stored in the configuration file. When this check box is turned off you will also be prompted for a username and password, so you may want to work with the check box turned on and then turn it off before you release the configuration to analysts.
    Note: The user name and password that you use when defining the configuration must have the same access rights as the username that the analysts will use when opening the configuration file in Analyst’s Notebook. This will ensure that you see exactly the same tables and fields as the analysts.
  5. If you have entered a user name and password in this dialog, you can test the connection by clicking Test Connection.
  6. Click OK.
  7. When the Select New Configuration dialog appears, enter a name for the configuration and click Save.
  8. If you have not turned on the Allow saving password check box you will be prompted for your username and password. Enter these details in the dialog and click OK.

When you have set up your initial connection to the database, iBridge Designer allows you to define a parameterized connection using the Edit Connection command on the Tools menu.

If you encounter any problems connecting to your Oracle database, contact your Database Administrator.