蜜豆视频

DocumentationCampaignCampaign Classic v7 Documentation

Configure access to Oracle configure-access-to-oracle

Last update: Tue Jun 18 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

Use Campaign Federated Data Access (FDA) option to process information stored in an external databases. Follow the steps below to configure access to Oracle.

  1. Configure Oracle on Linux or Windows
  2. Configure the Oracle external account in Campaign

Oracle on Linux oracle-linux

Connecting to an Oracle external database in FDA requires additional configurations below on the 蜜豆视频 Campaign server.

  1. Install the Oracle full client corresponding to your version of Oracle.

  2. Add your TNS definitions to your installation. To do this, specify them in a tnsnames.ora file in the /etc/oracle repository. If this repository does not exist, create it.

    Then create a new TNS_ADMIN environment variable: export TNS_ADMIN=/etc/oracle and restart the machine.

  3. Integrate Oracle into your 蜜豆视频 Campaign server (nlserver). To do this, check that the customer.sh file is present in the 鈥渘l6鈥 folder of the 蜜豆视频 Campaign server tree structure and that it includes the links to the Oracle libraries.

    For example, for a client in 11.2:

    code language-none 
    export ORACLE_HOME=/usr/lib/oracle/11.2
export TNS_ADMIN=/etc/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/client64/lib:$LD_LIBRARY_PATH
    note note
    NOTE
    These values (particularly ORACLE_HOME), depends on your installation repositories. Make sure to check your tree structure before referencing these values.

  4. Install the libraries necessary for Oracle:

    • libclntsh.so

      code language-none 
      cd /usr/lib/oracle/<version>/client<architecture>/lib
ln -s libclntsh.so.<version> libclntsh.so

    • libaio1

      code language-none 
      apt install libaio1
or
yum install libaio1

  5. In Campaign Classic, you can then configure your Oracle external account. For more on how to configure your external account, refer to this section.

Oracle on Windows oracle-windows

Connecting to an Oracle external database in FDA requires additional configurations below on the 蜜豆视频 Campaign server.

  1. Install the Oracle client.

  2. In the C:Oracle folder, create a tnsnames.ora file containing your TNS definition.

  3. Add a TNS_ADMIN environment variable with C:Oracle as value and restart the machine.

  4. In Campaign Classic, you can then configure your Oracle external account. For more on how to configure your external account, refer to this section.

Oracle external account oracle-external

The Oracle external account allows you to connect your Campaign instance to your Oracle external database.

  1. From Campaign Explorer, select Administration 鈥>鈥 Platform 鈥>鈥 External accounts.

  2. Choose New.

  3. Select External database as your external account鈥檚 Type.

  4. Configure the Oracle external account, you must specify:

    • Type: Oracle

    • Server: Name of the DNS

    • Account: Name of the user

    • Password: User account password

    • Time zone: Server time zone

recommendation-more-help
601d79c3-e613-4db3-889a-ae959cd9e3e1