Introduction
Datasources allow you to connect your APIs and your frontend to your own database. You can link your own databases, or use one provided by Canonic.
Each datasource consists of tables and an automatically generated CMS that's tailored to your database and adapts based on it's structure.
You can create and define any additional tables needed by the datasource powered by Canonic.
Supported datasources
We support the following database engines:
- MongoDB
- PostgreSQL
- MySQL
- MS SQL
Importing a datasource
You can import a datasource either when creating a project or through the navigation panel. Once the configuration opens, you can enter all configuration information and test your connection to the datasource.
Once the connection test completes, you can select all the tables inside the datasource that you would like to import and submit.
Canonic automatically tries to generate the structure and schemas for all the tables you selected to import. Once the process completes, your table is ready to use!
Database introspection might not be able to determine the entirety of your schema, so do verify all your tables and fix/create any missing links.
Modifying a datasource
You can modify an already imported datasource by clicking on it in the navigation panel.
You can delete the datasource and all associated tables from Canonic by right clicking on the datasource in the navigation panel and selecting Delete.
Configuration Options
Database Engine
The database engine your datasource is based on.
Database Title
The database's title. All the databases are grouped under the database title.
Connection String
The connection string for connecting to the database.