How to create a DB Connection

[Abhinav_mehta]

How can i connect a Database in vconnect?? and do i need to whitelist any IP for it?

[naveen.gupta]

To Create a Database connection in vConnect:

1. Login to Vahana Developer Portal.
2. Go to vConnect Module
3. Go to Database Database Connection Tab and add the database details and save and sync.

Yes we need to whitelist VRT Application Server (where dbes microservice is running) to the database server.

[Abhinav_mehta]

@naveen.gupta thanks for the answer.

[VivekBhardwaj]

Also, once the DB connection is setup and sync, you can test and confirm the same by following below steps:

a. For vDesigner 1.0 (without Release manager)

1. Go to vConnect >> “Database connection” module

2. You will see the newly created DB connection, like below screenshot:
   

   

3. Click on the “eye” icon () to view the connection details

4. You will view a pop-up with the list of connection details for each environments you have configured, as below:
   

   

5. At the bottom, you will see “Connection” label with 2 buttons, one to “Test Connection” (),
   other to “Reset Connection” ()

6. Click on “Test Connection” and it will show message on the top right corner of the pop-up as below:
   

   

7. If this is Successful, then the connection is confirmed.

[VivekBhardwaj]

The above details are for application running on Release Manager.
Typo mistake while mentioning “without Release Manager” instead of “with”

[VivekBhardwaj]

a. Follow below steps for vDesigner 1.0 (without Release manager)

1. Go to vConnect >> “Other” tab

2. Under “Db-def” tab, you will see the newly created DB connection for the first environment (sandbox/development/uat), like below screenshot:
   

   

3. You will see “Test/Reset Connection” label with 2 buttons, one to “Test Connection” (), other to “Reset Connection” ()

4. Click on “Test Connection” and it will show message on the top right corner of the pop-up as below:
   

   

5. If this is Successful, then the connection is confirmed.