Page Comparison

...

• Click Create > Connection. 
• In the Create New Connection screen, select your database management system, e.g. MySQL. 
• Provide the appropriate Host Name, Port Number, 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 procedures procedure to create a database connection in Canvas Studio are is listed as follows:

1. Log on to Canvas Studio with your credentials.
   
   
   
   
2. On the home page of Canvas Studio, click Create > Connection.
   
   
   
   
   The Create New Connection page appears.
   
   
   
   

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

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

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

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

7. Enter the server port number in the Port field 

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

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

11. Click Test. 

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

    
    
    
    

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