000026875 - How to setup OLE DB Connection for Oracle in an RSA Archer 5.x Data Feed

Document created by RSA Customer Support Employee on Aug 30, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000026875
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x
Platform: Oracle database
 
Issue
  • How to retrieve data and setting up OLE DB Connection for Oracle into Archer via Data Feed.
  • From the Source Data tab in a Data Feed, clicking Load Fields causes an error: An error occurred generating schema.
  • Unable to use the Oracle Client Data Driver to connect the Oracle database in Data Feed Manager.
Resolution

If still having a problem connecting to the Oracle database via Oracle Client data driver, alternatively you could consider to use the OLE DB data driver to communicate with Oracle database in Archer in Data Feed Manager.
There are procedures how to test and configure OLE DB data driver to connect the Oracle database to Archer as following:-


  1. Install the OLE DB data driver for the appropriate version of Oracle on the Archer server where Data Feed Manager is being ran.  NOTE: Make sure to reboot servers after installing driver.
  2. Download the Oracle Provider for OLE DB data driver. The Oracle Provider for OLE DB driver could be obtained from the Oracle website, www.oracle.com.
    1. For example, the 11g Oracle Provider for OLE DB. The link is http://www.oracle.com/technetwork/database/windows/index-089115.html
    2. Make sure to use the version of the package that matches the system type of your OLE DB data driver:
       
      • use the 64-bit version if you are running a 64-bit driver with Archer 64-bit system.
      • use the 32-bit version if you are running a 32-bit driver with Archer 32-bit system.
       
  3. Testing the connection between OLE DB data driver and Oracle database by using the Data Link Properties dialog. The Data Link Properties is the standard Windows System interface for configuring connection string to data source. This dialog box contains all the properties that the selected OLE DB provider supports. There are the procedures how to configure the OLE DB data driver for Oracle Provider and then test in the Data Link Properties.
    1. From the Data Link Properties Dialog, Select the Provider tab and then select the OLE DB data provider for Oracle.
    2. Click Next to go to Connection tab.
    3. Under the Connection Tab, enter server name, User name and Password.
    4. Click on Test Connection. If connection is successful continue on, otherwise double check the details of your server name, Username and Password.
  4. Configure the Transport page in Data Feed setting in Archer to use Oracle Provider for OLE DB with the Connection string.
    1. Sample Connection string with Oracle Provider for OLE DB:
       
      Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

       
For more details on Oracle connection strings: http://www.connectionstrings.com/oracle.
Legacy Article IDa65484

Attachments

    Outcomes