Database configuration to upload the database schema from external databases to Jiffy.

Create DB Connection

To add a DB Connection, do the following:

1. Click on the + icon on the Datasets listing page and choose the DB Connection option.

2. In the New DB Connection dialog box that opens, specify the following details:

   • Name: Name of the DB Connection.
   • Type: A dropdown field to select the required DB to be connected to. The following options are available:
     • DB2
     • MS SQL
     • MYSQL
     • ORACLE
     • POSTGRES
   • Require SSL/TLS: A checkbox that can be ticked if the SSL (Secure Sockets Layer) and TLS (Transport Security Layer) cryptographic protocols are required or not.

   SSL and TLS are both cryptographic protocols that provide authentication and data encryption between servers, machines, and applications operating over a network (e.g. a client connecting to a web server).

3. Click on the TEST CONNECTION button to check if the connection is established properly. If the test connection is successful, a green tick mark appears in the TEST CONNECTION button.

   If a test connection fails, a **DB Test connection failed, please try again** popup appears and the **New DB Connection** dialog box appears again with the previously entered details. The user can check if the correct details are provided are correct and modify them accordingly. If the connection fails again, a message **Please contact System Administrator and alternatively provide different DB Connection details** is displayed.

4. The newly created DB Connection gets listed in the Datasets listing screen.