2. Create a DB Connection

You can easily create a database connection in Canvas Studio with viable and feasible configurations. To serve the purpose of establishing a connection with your schema, a database connection is created to facilitate the process of fetching the data from the schema.

A brief overview on creating a database connection in Canvas Studio is provided as follows:

In Canvas Studio, click Create > Connection.
In the Create New Connection screen, select your database management system, e.g. MySQL.
Provide a unique name in the Connection Name field.
Provide the appropriate Host Name, Port number, DB/Schema Name, User Name and Password.
To test the connection, click Test.
Once the connection gets tested successfully, click Save to save the connection.

The step-by-step procedure to create a database connection in Canvas Studio is listed as follows:

Log on to Canvas Studio with your credentials.
On the home page of Canvas Studio, click Create > Connection.

The Create New Connection page appears.
In the Create New Connection page, in the Connection Type, click Data Base.
Enter an unique name for the connection in the Connection Name field, e.g. NEW CONNECTION.
Click the database used for your application, e.g. MySQL.
Enter the server name that hosts the database in the Host Name field.
Enter the server port number in the Port field
Enter the database or the schema name in DB/Schema Name field, e.g. smartbank.
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.
Click Test.

If the provided credentials are correct, a successful message appears else a failure message appears. If a failure message appears, enter the correct credentials and click Test again.
Click Save.

A confirmation message, indicating a successful save, appears.
Click Ok.

After you create a DB connection, refer Create a DB Data Source.