Overview
One of the core strengths of Canonic lies in its ability to seamlessly connect with various datasources, enabling you to leverage the power of external databases and third-party integrations. Whether you're working with traditional databases like MySQL or incorporating data from third-party services like Shopify, Canonic provides a unified and efficient approach to data connectivity.
External Databases
Canonic simplifies the process of connecting to external databases, allowing you to integrate data seamlessly into your applications. Here's how you can connect to a popular databases (MySQL, MongoDB, PostgreSQL, etc) and run your queries:
- Navigate to the Workflows section in your Canonic Project.
- Create a new Workflow and add a new DB Query Node
- Select which database you want to connect to, we select MySQL for this example.
- Enter your database connection details, including the host, port, username, and password.
- Input your SQL query:
Example for SQL: SELECT * FROM users WHERE last_login > '2024-01-01'
Once configured, you can now access your MySQL data within Canonic.
Third-Party Integration
In addition to traditional databases, Canonic empowers you to integrate seamlessly with third-party services (Shopify, Google Sheets, Airtable, etc), enhancing the functionality and data richness of your applications.
Shopify
- Navigate to the Workflows section in your Canonic Project.
-
Create a new Workflow and add a new Integration Node
-
Select which integration you want to connect to, we select Shopify for this example.
-
Select the Shopify API you want to integrate with, we we’ll try to fetch the List of products for this example.
- Input your Shopify API Key and required store name for Canonic to establish a connection to your Shopify store, enabling you to fetch and update data effortlessly.
Congratulations! You've successfully learned how to connect Canonic to external databases and third-party services. With this newfound capability, you can harness the full potential of data integration in your applications. If you have any questions or need further assistance, join our vibrant community on Discord. Happy coding with Canonic! 🚀