| Table of Contents | ||
|---|---|---|
|
Navigate to the integration section. Scroll down to the data file and storage section. Locate the data store for MySQL.
...
You can create a free account at: https://console.aiven.io/
Once you create your account, open your project, navigate to "Services," and select your SQL service.
...
Once you open your service, navigate to the "Overview" section and copy the credentials.
...
Fill in Credentials:
Obtain your MySQL credentials from the email confirmation received from your MySQL database server.
Copy the server name and paste it into the host field. Remove "HTTP" from the server name.
Set the port
Enter your username, which typically doubles as your database name.
Input your password (ensure its security).
Optionally, fill in the CA certificate if available.
Whitelist IP addresses if required by your hosting provider.
...
Verifying Connection:
Once you filled up all the details press “Save”. Now you can see the status is verified and also you can Sync and Create your records.
...
Creating a New Data Store:
If you don't have existing data stores, press the sync button to fetch available data stores.
Alternatively, create a new data store by providing a name (e.g., "students_detail") and defining fields (e.g., Name, Email, Age).
...
A new table has been successfully created. You can edit or view the record by clicking on "Browse."
...
You can view the records within the table and make edits, as well as add new ones as needed.
...
Integration in Flow Builder
Create a new flow.
Add action node and select "Integrations."
Choose "Data Store" actions.
Select desired actions like adding a new record.
Fill in the details and test.
You can use different functions as per your needs.
After using any of the functions, you can proceed to view and edit the data as needed.