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:
-
Host and Port:
- For local servers, the host is typically
localhost
and the default port is1521
. - 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.
- For local servers, the host is typically
-
SID or Service Name:
- To find your SID or Service name:
- Using SQL*Plus or SQL Developer:
- Connect to your Oracle database using SQL*Plus or SQL Developer.
- Execute the following query:
or
select instance from v$thread
SELECT sys_context('userenv', 'service_name') AS service_name FROM dual;
- The result will display the SID or service name of your Oracle database.
- Checking the TNSNAMES.ORA File:
- Locate and open the
tnsnames.ora
file on your system. This file is usually found in theORACLE_HOME/network/admin
directory. - Look for the entry corresponding to your database connection. The
SERVICE_NAME
orSID
will be listed within this entry.
- Locate and open the
- Note down the SID or service name as it will be used to connect to your Oracle database.
- Using SQL*Plus or SQL Developer:
- To find your SID or Service name:
-
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:
- Save the configuration settings.
- Test the connection to Oracle database from your application to ensure everything is set up correctly.
- Run a test query or check the connection status to verify successful connectivity.
Your Oracle connector is now configured and ready to query data from your Oracle database.
Supported sync modes
Mode | Supported (Yes/No/Coming soon) |
---|---|
Incremental sync | YES |
Full refresh | Coming soon |
This guide will help you seamlessly connect your AI Squared application to Oracle Database, enabling you to leverage your database’s full potential.