Search

DB Configuration

Last Updated: Feb 14, 2022

Articles

Database configuration is used to upload the database schema from external databases to JIFFY.ai.

Create DB Configuration

To add a DB Configuration, do the following:

  1. Click on the + icon on the Datasets page and select the DB Configuration option.
  2. The Connection Name dialog box appears. Enter the following details:
    Image description
    • Name: Name of the DB Configuration.
    • Type: A drop-down field to select the required DB to be connected to. The following options are available:
      • DB2
      • MS SQL
      • MYSQL
      • ORACLE
      • POSTGRES
    • URL: URL of the external DB.
    • Username: Username of the external DB.
    • Password: Password of the external DB.
  3. Click on the TEST CONNECTION button to check if the connection is established properly.
  4. The newly created DB Connection gets listed in the Datasets listing page.
    Click the name of the DB Configuration to navigate to the SQL Editor page where all the tables in that DB are listed.
    You can use these tables in the SQL Dataset to create the required dataset for further processing.

JDBC URL Format

Generic format of the connection URL supported by different JDBC drivers are listed below:

Database JDBC URL formats
DB2 jdbc:db2:[schema]
MYSQL protocol//[hosts][/database][?properties]
MS SQL jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
POSTGRES jdbc:postgresql://host:port/database?properties
Oracle
  • Connect to SID: jdbc:oracle:thin:[/]@[:]:
  • Connect to Oracle service name: jdbc:oracle:thin:[/]@//[:]/
  • URL with tnsnames.ora entries: jdbc:oracle:thin:
    @(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SERVICE_NAME=)))

Connection URL to connect to PostgreSQL is jdbc:postgresql://localhost:5432/testdb

Use IP address in case server URL does not work, for example, jdbc:postgresql://xx.1.24.10:xxyy/testdb

Did you find what you were looking for?