Skip to main content

​
Intro

MySQL is an open-source relational database management system. The MySQL SSH Writeback connector supports a secure connection to export your data from a Domo DataSet to the provided MySQL database. You export data to a MySQL database in the Data Center. You configure your Domo-MySQL connection in the Data Center. This topic discusses the fields and menus that are specific to the MySQL SSH Writeback Connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.
Note: The owner of a writeback dataset must also be an owner or co-owner of the input dataset.

​
Prerequisites

To configure this connector, you must have the following:
  • The hostname of the server you are SSH-tunneling through
  • Your SSH server port number, username, password, private key, and private key passphrase
  • The hostname or IP address of your database server
  • Your MySQL port number, username, password, and database name
Note: Domo does not support the SSH keys generated using ssh-keygen. The SSH keys need to be the DES or RSA keys generated by OpenSSL.
Important: You will need the following permissions on MySQL:
  • FILE
  • CREATE
  • DROP
  • INSERT
  • SELECT
  • UPDATE

​
Configuring the Connection

This section enumerates the options in the Credentials and Details panes in the MySQL SSH Writeback Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most Connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your MySQL account where you want your data to be copied to. The following table describes what is needed for each field:

Field

Description

SSH Server Host Name Enter your SSH server host name.
SSH Port Number Enter your SSH server port number.
SSH Username Enter your SSH sever username.
SSH Password Enter your SSH server password.
SSH Private Key Enter the SSH private key in PEM format (either DES or RSA).
SSH Private Key Passphrase Enter your SSH server private key passphrase.
MySQL JDBC Driver Select the MySQL JDBC driver to use.
Host Enter your hostname or IP address of your database server.
Port Enter your MySQL port number.
Username Enter your MySQL username.
Password Enter your MySQL password.
Database Enter your MySQL database name.
Once you have entered valid credentials, you can use the same account any time you go to set up a new Domo-MySQL connection. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

​
Details Pane

This pane contains a number of fields for specifying your data and indicating where it’s going.

Menu

Description

DataSet ID

Enter your Domo dataset ID(GUID) located in the dataset URL.

For example, in the URLhttps://mycompany.domo.com/datasources/845305d8-da3d-4107-a9d6-13ef3f86d4a4/details/overview{” ”}, the DataSet ID is 845305d8-da3d-4107-a9d6-13ef3f86d4a4.

How would you like to select your table?Specify whether you would like to create a new table or select an existing table to export your DataSet data to.
Table Name

Select whether you would like to use the dataset ID or a custom name for the table name.

Custom Table Name Enter the name for the SQL table to write the dataset data to.
Delete existing table and create a new table with the same name

Select this checkbox if you want Domo to delete the existing table and create a new one with the same name.

WARNING : This deletes the existing table and the data cannot be recovered once deleted.

Existing Table Select the table to write the dataset data to.
Update Operation Type

Select whether you want to append data, overwrite new data, or upsert data while updating it.

Use Column MappingSelect the checkbox if you wish to provide Dataset Column Name and Table Column Name mapping. If this option is selected, only those columns that are provided in the Text Areas will be updated/inserted.
Dataset Column Names Enter the comma separated list of Dataset Column Names.
Table Column NamesEnter the comma separated list of Table Column Names. Table Column Names should correspond to the Dataset Column Names in the same sequence. The Number of Dataset Column Names should be equal to Table Column Names for proper mapping.
Primary Column Select the column name that should be primary key column.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

​
FAQs

You need the following:
  • The hostname of the server you are SSH-tunneling through
  • Your SSH server port number, username, password, private key, and private key passphrase
  • The hostname or IP address of your database server
  • Your MySQL port number, username, password, and database name
  • You also need to s elect the MySQL JDBC driver to use
No
Your Domo input dataset id is in the URL of the dataset you are exporting data from. For example: https://customer.domo.com/datasources/aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee/details/settings

​
Troubleshooting

  • Make sure your authentication remains valid.
  • Review the configuration to make sure that all required items have been selected.
  • Review the Connector history for error messages.
  • In rare cases, you may be requesting too much information and reaching API limitations or timeouts. If this is the case, you can review the history of the Connector run to see the error message and duration. If this is the case, you can reduce the number of accounts that are being pulled, choose a smaller number of metrics for the report that you are pulling, or reduce the timeframe that you are trying to pull.