2. Create a DB Connection

After you log on to Canvas Studio, perform the following steps to create a database connection:

1. On the home page of Canvas Studio, click Create > Connection.
   
   
   
   
   The Create New Connection page appears.
   
   
   
   

2. In the Create New Connection page, in the Connection Type, click Data Base.

3. Enter an unique name for the connection in the Connection Name field, e.g. NEW CONNECTION.

4. Click the database used for your application, e.g. MySQL.  

5. Enter the server name that hosts the database in the Host Name field.

6. Enter the server port number in the Port field 

7. Enter the database or the schema name in DB/Schema Name field, e.g. smartbank. 

8. Enter the user name to connect to the database in the User Name field.
9. Enter the password to connect to the database in the Password field.
   
   
   
   

10. 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.

    
    
    
    

11. Click Save.
    
    
    
    A confirmation message, indicating a successful save, appears. 
    
    
12. Click Ok. 
    
    After you create a DB connection, refer 3. Create a DB Data Source.