Setup

Clone Teradata/mule-jdbc-example repository:

  git clone https://github.com/Teradata/mule-jdbc-example

Edit src/main/mule/querying-a-teradata-database.xml, find the Teradata connection string jdbc:teradata://<HOST>/user=<username>,password=<password> and replace Teradata connection parameters to match your environment.

Note

Should your Teradata instance be accessible via Teradata Trial, you must replace <HOST> with the host URL of your Teradata Trial environment. Additionally, the 'user' and 'password' should be updated to reflect your Teradata Trial environment's username and password.

Create a sample database in your Teradata instance. Populate it with sample data.

 -- create database
 CREATE DATABASE HR
   AS PERMANENT = 60e6, SPOOL = 120e6;

 -- create table
 CREATE SET TABLE HR.Employees (
   GlobalID INTEGER,
   FirstName VARCHAR(30),
   LastName VARCHAR(30),
   DateOfBirth DATE FORMAT 'YYYY-MM-DD',
   JoinedDate DATE FORMAT 'YYYY-MM-DD',
   DepartmentCode BYTEINT
 )
 UNIQUE PRIMARY INDEX ( GlobalID );

 -- insert a record
 INSERT INTO HR.Employees (
   GlobalID,
   FirstName,
   LastName,
   DateOfBirth,
   JoinedDate,
   DepartmentCode
 ) VALUES (
   101,
   'Test',
   'Testowsky',
   '1980-01-05',
   '2004-08-01',
   01
 );

Open the project in Anypoint Studio.
- Once in Anypoint Studio, click on Import projects..:
- Select Anypoint Studio project from File System:
- Use the directory where you cloned the git repository as the Project Root. Leave all other settings at their default values.
- If prompted to update the workspace, keep all the default options selected and click Perform update.
This updates the project configuration so it is compatible with the current version of Anypoint Studio.