Query Teradata Data in MySQL Workbench

MySQL Workbench allows users to administer MySQL environments and gain better visibility into databases. When paired with CData Connect (on-premise or Connect Server), you get live access to Teradata data as if it were a MySQL database. This article shows how to create a virtual database for Teradata in Connect and work with live Teradata data in MySQL Workbench.

Create a Virtual MySQL Database for Teradata Data

CData Connect uses a straightforward, point-and-click interface to connect to data sources and generate APIs.

1. Login to Connect and click Connections.
2. Select "Teradata" from Available Data Sources.
3. Enter the necessary authentication properties to connect to Teradata.

   To connect to Teradata, provide authentication information and specify the database server name.

   • User: Set this to the username of a Teradata user.
   • Password: Set this to the password of the Teradata user.
   • DataSource: Specify the Teradata server name, DBC Name, or TDPID.
   • Port: Specify the port the server is running on.
   • Database: Specify the database name. If not specified, the default database is used.
4. Click Save Changes
5. Click Privileges -> Add and add the new user (or an existing user) with the appropriate permissions.

With the virtual database created, you are ready to connect to Teradata from MySQL Workbench.

Query Teradata from MySQL Workbench

The steps below outline connecting to the virtual Teradata database in Connect from MySQL Workbench and issuing basic queries to work with live Teradata data.

Connect to Teradata through Connect

1. In MySQL Workbench, click to add a new MySQL connection.
2. Name the connection (CData Connect).
3. Set the Hostname, Port, and Username parameters to connect to the SQL Gateway.
4. Click Store in Vault to set and store the password.
5. Click Test Connection to ensure the connection is configured properly and click OK.

Query Teradata Data

1. Open the connection you just created (CData Connect).
2. Click File -> New Query Tab.
3. Write a SQL query to retrieve Teradata data, like SELECT * FROM teradatadb.NorthwindProducts;

With access to live Teradata data from MySQL Workbench, you can easily query and update Teradata, just like you would a MySQL database. Request a demo of the CData Connect and start working with Teradata just like a MySQL database today.