You can add a connection to a MySQL database using ThoughtSpot DataFlow.
Follow these steps:
-
Click Connections in the top navigation bar.
-
In the Connections interface, click Add connection in the top right corner.
-
In the Create Connection interface, select the Connection type.
-
After you select the MySQL Connection type, the rest of the connection properties appear.
- Connection name
Name your connection. - Connection type
Choose the MySQL connection type. - Host
Specify the hostname or the IP address of the MySQL system - Port
Specify the port associated to the MySQL system - User
Specify the user id that will be used to connect to the MySQL system. This user should have necessary privileges to access the data in the databases - Password
Specify the password for the App User - Version
Specify the MYSQL version being connected to. - JDBC options
Specify the options associated with the JDBC URL.
See Connection properties for details, defaults, and examples.
- Connection name
-
Click Create connection.