Obtain the JDBC Connection String for Your Database

Depending on the database you are using, follow the instructions in the respective section to obtain the JDBC connection string:

Oracle Database

The format of the JDBC connection string for Oracle Database is:

jdbc:oracle:thin:@HOSTNAME:1521/DATABASENAME

For example:

jdbc:oracle:thin:@benqoiz.southeastasia.cloudapp.azure.com:1521/pdb1

Azure Database for PostgreSQL

To obtain the JDBC connection string for Azure Database for PostgreSQL, do the following:

Deploy an Azure Database PostgreSQL as described in Quickstart: Create an Azure Database for PostgreSQL server in the Azure portal.
Access the Azure portal at https://portal.azure.com, and go to the service instance.
Click Connection Strings under Settings.
Locate the JDBC section and click the copy icon on the right to copy the JDBC connection string to the clipboard. The JDBC connection string will be similar to the following:
```
jdbc:postgresql://20191015cbfgterfdy.postgres.database.azure.com:5432/{your_database}?user=jroybtvp@20191015cbfgterfdy&password={your_password}&sslmode=require
```
When passing this value to the datasourceConfig-postgres.sh command, remove the database user and password values, and place them as arguments to the script (<dsUser> and <dsPassword>. In the above JDBC connection string sample, the value for dsConnectionURL argument after removing the database user and password, will be:
```
jdbc:postgresql://20191015cbfgterfdy.postgres.database.azure.com:5432/{your_database}?sslmode=require
```

Azure SQL Server

To obtain the JDBC connection string for Azure SQL Server, do the following:

Deploy Azure SQL Server as described in Quickstart: Create a single database in Azure SQL Database using the Azure portal, PowerShell, and Azure CLI.
Access the Azure portal at https://portal.azure.com, and go to the service instance.
Click Connection Strings under Settings.
Locate the JDBC section and click the copy icon on the right to copy the JDBC connection string to the clipboard. The JDBC connection string will be similar to the following:
```
jdbc:sqlserver://rwo102804.database.windows.net:1433;database=rwo102804;user=jroybtvp@rwo102804;password={your_password_here};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
```
When passing this value to the datasourceConfig-azuresql.sh command, remove the database user and password values, and place them as arguments to the script (<dsUser> and <dsPassword>. In the above JDBC connection string sample, the value for dsConnectionURL argument after removing the database user and password, will be:
```
jdbc:sqlserver://rwo102804.database.windows.net:1433;database={your_database};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
```