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