Connecting to Teradata

Note

This documentation is prior to May 2022.

Teradata is an open-source Database Management System for developing large-scale data warehousing applications. This tool provides support for multiple data warehouse operations simultaneously using the concept of parallelism.

There are three options to connect to MySQL:

• Create a new project
• Edit an existing project connection
• Export data from the Export >Run recipe button

Connecting to Teradata when creating a new project

1. Click Enrich. The Enrich page is displayed.
2. Click  in the upper-right hand corner. The Create a new project window is displayed.
3. Type in a new project name. The project name needs to be unique.
4. Select a use case from the drop-down.
5. Click Create project. The Upload a dataset window appears.
   
6. Select Teradata. The following screen is displayed for a new database connection creation:
   
7. All the fields are mandatory. Choose a connection name.
8. Type in the Host.
9. Type in the Port number.
10. Type in the Database name.
11. Type in the User name.
12. Type in the Password.
13. Type in the Temp Schema.
14. Click Create. A message is displayed that the connection was successfully created. If the test connection failed, then you are unable to create a connection.

Connecting to MySQL when editing a dataset

1. Click Enrich. The Enrich page is displayed.
2. Create or search for a project.
3. Click .
   
4. The Change data and edit dataset window is displayed.
   
5. Click Continue.
6. Select Teradata. The following screen is displayed for a new database connection creation:
   
7. All the fields are mandatory. Choose a connection name.
8. Type in the Host.
9. Type in the Port number.
10. Type in the Database name.
11. Type in the User name.
12. Type in the Password.
13. Type in the Temp Schema.
14. Click Create. A message is displayed that the connection was successfully created. If the test connection failed, then you are unable to create a connection.

Exporting data

1. Click Enrich. The Enrich page is displayed.
2. Create, search or edit a project.
3. Click the Export >Run Recipe.
   
4. The Schedule Recipe Run window is displayed.
   
5. Select the input connection (optional).
6. Select the output connection.