Oracle

​

Connect AI Squared to Oracle

This guide will help you configure the Oracle Connector in AI Squared to access and transfer data to your Oracle database.

​

Prerequisites

Before proceeding, ensure you have the necessary host, port, SID or service name, username, and password from your Oracle database.

​

Step-by-Step Guide to Connect to Oracle database

​

Step 1: Locate Oracle database Configuration Details

In your Oracle database, you’ll need to find the necessary configuration details:

1. Host and Port:

   • For local servers, the host is typically localhost and the default port is 1521.
   • For remote servers, check your server settings or consult with your database administrator to get the correct host and port.
   • Note down the host and port as they will be used to connect to your Oracle database.

2. SID or Service Name:

   • To find your SID or Service name:
     1. Using SQL*Plus or SQL Developer:
        • Connect to your Oracle database using SQL*Plus or SQL Developer.
        • Execute the following query:

          select instance from v$thread
          

          or

          SELECT sys_context('userenv', 'service_name') AS service_name FROM dual;
          

        • The result will display the SID or service name of your Oracle database.
     2. Checking the TNSNAMES.ORA File:
        • Locate and open the tnsnames.ora file on your system. This file is usually found in the ORACLE_HOME/network/admin directory.
        • Look for the entry corresponding to your database connection. The SERVICE_NAME or SID will be listed within this entry.
     • Note down the SID or service name as it will be used to connect to your Oracle database.

3. Username and Password:

   • In the Oracle, you can find or create a user with the necessary permissions to access the database.
   • Note down the username and password as it will be used to connect to your Oracle database.

​

Step 2: Configure Oracle Connector in Your Application

Now that you have gathered all the necessary details, enter the following information in your application:

• Host: The host of your Oracle database.
• Port: The port number of your Oracle database.
• SID: The SID or service name you want to connect to.
• Username: Your Oracle username.
• Password: The corresponding password for the username.

​

Step 3: Test the Oracle Database Connection

After configuring the connector in your application:

1. Save the configuration settings.
2. Test the connection to Oracle database from your application to ensure everything is set up correctly.

By following these steps, you’ve successfully set up an Oracle database destination connector in AI Squared. You can now efficiently transfer data to your Oracle database for storage or further distribution within AI Squared.

​

Supported sync modes

This guide will help you seamlessly connect your AI Squared application to Oracle Database, enabling you to leverage your database’s full potential.