Skip to main content

Load Metadata from a Teradata Database

Use the Teradata Loader to upload metadata to Alteryx Connect for a specified Teradata database.

Review Loader Requirements

  • The Alteryx Connect Loaders must be installed on the machine where Alteryx Server is installed. To install the loaders:

    1. Download the loaders installer. For compatibility, the Loaders installer version must match the Alteryx Connect version.

    2. Run the installer as an administrator.

  • The Teradata user account requires elevated permissions to access DBC system tables, schemas, and other content.

  • The Teradata ODBC driver must be installed. See Teradata Downloads.

Open the Loader

  1. Open Alteryx Designer.

  2. Select Help > Sample Workflows > Alteryx Connect Metadata Loaders > Teradata Loader > Teradata Loader.

Run the App

  1. Select Run as Analytic App

    Run as analytic app button

    .

  2. In the Teradata server tab:

    • Type the Teradata connection information, including server, database, and credentials.

    • In Schemas to load, optionally specify a comma-separated list of schemas. Leave blank to load all schemas.

    1. In the Alteryx Connect tab, type the URL for your Alteryx Connect instance and your credentials.

      https://yourcompany.alteryxconnect.com

    2. Before running the app, select Save button and save the app configuration to the following directory:

      C:\ProgramData\Alteryx\AlteryxConnect\Teradata_Loader\

      The .yxwv app values file is used for scheduling the loader to run in the Gallery. See Schedule Metadata Loaders.

  3. Select Finish to run the app.

    • If the run succeeds, "Success" appears in the App Results window.

    • If the run fails, a "There were Errors" message appears.

    Depending on how much metadata is being imported, the app can take a long time to run.

View the Metadata

  1. Go to the Alteryx Connect URL and log in.

  2. From the main menu, select Data Sources > Databases.

  3. Select a folder to view its contents.