Intro
MySQL users can connect their data to Domo through Cloud Amplifier native integration. Provide connection parameters and select the tables you want to see as Domo DataSets. Follow the steps in this article to configure your read-only MySQL-Domo connection with Cloud Amplifier.Configure Read-only Connection to MySQL
- Navigate to the Domo Data Center.
-
(Conditional) If you’re not already there, use the sidebar to go to the
Data Warehouse.
-
Select
Add New Cloud Account.
The Amplify existing cloud warehouses modal displays.
-
In the
Native integration section, choose See More to see the rest of the options.
-
Select
MySQL.
-
Select
+ Add New Integration.
-
Enter the following connection parameters in the appropriate fields:
- Integration name — If you need to update your integration in the future, this is the name to search for in the list of integrations.
- Integration description (optional) — Enter any additional information about the integration.
- MySQL connection URL — Enter the host and port that represents the MySQL instance you are connecting to. Ex. myhost.com:3306
- MySQL username — The MySQL instance username that has access to the data you are connecting to.
-
MySQL password —
The password for the MySQL user.
-
Configure caching options. You can choose whether to automatically check for data updates and at what interval. Learn about Cloud Amplifier
caching rules.
- Select Next. A success message displays.
-
Select
Choose Tables to Connect to open the table picker.
-
Select from schemas and tables and when you’re ready, select
Create DataSets.
-
(Optional) In the confirmation modal, you can share your DataSets with other Domo users.
