Create a Database Connection

After you log into Canvas Studio, perform the following steps to create a database connection.

Click Create > Connection.

The Create New Connection page appears.
In the Create New Connection page, in the Connection Type, click Data Base.
Enter a unique name for the connection in the Connection Name field.
Click the database used for your application. By default, Oracle appears selected.
Enter the server name that hosts the database in the Host Name field. Use the database server's natted IP address in case direct IP is not working.
Enter the server port number in the Port field.

SID and Service Name fields are mutually exclusive, which means when SID is used, Service Name is not required and vice versa.
If Oracle 12c is the database, choose SERVICE NAME option and enter the database service name in the Service Name field. For Oracle 11g, choose SID option and enter the security identifier of the database in the SID field.
- If you select MySQL as the database, enter the database or the schema name in DB/Schema Name field.
- If you select PostgreSQL as the database, enter the database name in DB Name field and the schema name in Schema Name field.
Enter the user name to connect to the database in the User Name field.
Enter the password to connect to the database in the Password field.

To create connections on the SIR environment, it is required to use Natted IP information from the SIR's database server instead of the IP address from SQL developers. Kindly contact the IT team for the Natted IP information for any specific SIR environment.
Click Test. If the provided credentials are correct, a successful message appears else a failure message appears. If failure message appears, enter the correct credentials and click Test again.
Click Save.
The database connection is established with the provided information. If the connection is successful, the following message appears:

After you create a DB connection, refer Create a DB Datasource.