Skip to Content

Teradata connection guide for Jitterbit App Builder

Overview

This guide describes the system requirements and instructions for connecting App Builder to a Teradata database server.

System requirements

Database server

Teradata Database Server

Client web browser

  • Chrome TM 60 or newer

  • Firefox ® 55 or newer

  • Safari ® 11.0.2 or newer

Connection instructions

Adding a server

  1. Navigate to the App Builder IDE

  2. From the Connect menu, click on the Connect to your enterprise link

    attachment

  3. Click the Create button on the top left of the Data Servers panel. This will bring up the Add Server page.

Filling in credentials

To connect to an Teradata server, provide the following information:

  • Name: An identifiable and unique server name

  • Type: Select Teradata from the dropdown menu

  • Hostname: Enter the hostname of the Teradata database.

  • User Name: The user name with which you access the database server

  • Password: The password associated with the above user name

C:\Users\Richard\AppData\Roaming\PixelMetrics\CaptureWiz\Temp\5.png

After filling in all necessary credentials, click the Save button to save the settings.

Testing the connection

  1. Click the Test Connection button beneath the server information to make sure the server is properly connected.

  2. Upon successful connection, click the App Builder IDE menu heading at the top of the page to return to the App Builder IDE.

Adding a data source

After the server settings have been saved, the database needs to be connected to App Builder. Databases that are connected to App Builder are referred to as a data source.

  1. Navigate to the App Builder IDE.

  2. Click the Build your application link from the Build menu.

  3. Click the Data Storage Layer link, then Create a new data source record.

  4. Some data sources are automatically imported to the App Builder data storage page. If the data source has already been added, click on the associated Pop-Up icon to bring up the details page. If not, click the Create button on the top left of the page.

  5. Fill in the following credentials for the data source:

    1. Data Source Server: The name of the server being drawn from

    2. Data Source Name: Give the data source a unique display name

    3. Database Name: Enter the database name as it appears in the database server

    4. Schema Name: Allows the user to select a Schema name from a drop down menu

    5. Import Pattern: This allows users to import only certain tables by listing them in the box. Prefixes can also be used to only import a subset of tables (for example, MyApp_* will only import tables that start with "MyApp_"). If the space is left blank, it will import all tables.

    attachment

  6. Click Save to update the data source settings.

  7. Once the page refreshes, click the Import button that appears below the source credentials. When prompted, click Proceed. The import will be scheduled to run in the background.

  8. Click the Import button and, when prompted, click Proceed to import your server's data source.

    attachment