Skip to main content

Oracle Connector

The Oracle connector is now a standalone connector. Oracle databases have a unique approach to database organization compared to other systems like MySQL or SQL Server. In Oracle, what is often referred to as a "database" in other systems is more akin to a "schema" in Oracle. To connect to an Oracle database schema using the Abacus.AI platform, you need to provide the following configuration details:

Understanding Oracle Naming​

In Oracle, the Service Name is used to connect to a database instance. It is typically composed of:

Service Name = DB_NAME + DB_DOMAIN

For example, if DB_NAME is orcl and DB_DOMAIN is example.com, the service name would be orcl.example.com.

Configuration Details​

When setting up the Oracle connector, you will need to provide the following information:

  • Database Server URL/IP: The hostname or IP address of the Oracle database server.
  • Database Name: The Oracle service name followed by a dot and the schema name you want to connect to, in the format service_name.schema_name. For example: orcl.example.com.HR (where orcl.example.com is the service name and HR is the schema).
  • Database Port: The port number on which the Oracle database is running (default is typically 1521).
  • Database Username: The username assigned to access the Oracle database.
  • Database Password: The password associated with the username for database access.
  • Use TCPS (Optional): A toggle to indicate whether the Oracle database uses the SSL/TLS protocol for secure connections. By default, this is set to "No". If your database requires TCPS, toggle this option to "Yes".

Steps to Connect to Oracle​

  1. Gather Required Information: Obtain the following details from your Oracle database administrator:

    • The database server URL or IP address.
    • The database port (default is 1521).
    • The Oracle service name (DB_NAME + DB_DOMAIN, e.g., orcl.example.com).
    • The schema name you want to access.
    • The username and password for authentication.
    • Whether the database requires TCPS (SSL/TLS) for secure connections.

  2. Whitelist Abacus.AI IPs: Ensure that the Abacus.AI IP addresses are whitelisted in your Oracle database's firewall or security settings. Contact Abacus.AI support for the most up-to-date IP addresses.

  3. Set Up the Connector:

    • Navigate to the Abacus.AI Connected Services Dashboard.
    • Click on the Add New Connector button at the top right corner of the page.
    • Select the Oracle connector from the list of available connectors.
    • Fill in the required configuration fields:
      • Database Server URL/IP: Enter the hostname or IP address of the Oracle database server.
      • Database Name: Enter the service name followed by a dot and the schema name (e.g., orcl.example.com.HR).
      • Database Port: Enter the port number (default is 1521).
      • Database Username: Enter the username for database access.
      • Database Password: Enter the password for the username.
      • Use TCPS: Toggle this option to "Yes" if your database requires SSL/TLS for secure connections. Otherwise, leave it as "No".

  1. Save and Verify:

    • Click the Save button to save the configuration.
    • Click the Verify button to test the connection. If there are any errors, follow the error message to troubleshoot the configuration.

  2. Manage Your Connector:

    • Once verified, you can rename, edit, or delete the Oracle connector from the Connected Services Dashboard.