• 2) Studio for SQL Server dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting, analysis, and a lot more. SQL developers and DBAs performing complex database tasks can use the GUI tool to speed up almost any database experience, such as designing databases, writing SQL code, comparing databases, synchronizing schemas and data.
• Power BI Tutorial. Power BI is one of the most popular Data Visualization and Business Intelligence tool. The Power BI tool is the collection of apps, data connectors, and software services which are used to get the data from different data sources, transforms data, and produces useful reports.

Teradata Parallel Transporter (TPT)

Teradata Parallel Transporter aka TPT is new generation utility tool aim to create one stop tool for all the activities related to loading and exporting of date from/to Teradata database. Teradata advise to prefer TPT over existing utilities such as fastload, fastexport, multiload & tpump.

If you are currently running AQT v9, the install file will de-install AQT v9 and install AQT v10. All your settings and saved files will be retained. If you are running a version prior to AQT v9, your existing version will not be de-installed by the AQT v10 install. Once AQT v10 has been installed, you will have both versions on your machine.

Some of the operation that can be performed using TPT:

• Exporting data from Teradata database table to file.
• Loading data from file to Teradata database table.
• Loading data from Teradata database table to Teradata database table.
• Loading data from Teradata database table to other database table.

TPT job/script consist of three major parts:

1. DEFINE JOB: It is mandatory to define the TPT job. It is the outermost layer where 'Operators','Schema' and 'Apply' can be defined for TPT job.
   Syntax: Without defining character set(no UNICODE data)
   Syntax: Defining character set(UNICODE data)
   Syntax: With external Schema using 'Include'
   APPLY: This is required to execute the operations defined in the TPT job. Basic syntax of apply statement
   There can be three types of TPT jobs
   • Single APPLY statement in the job without 'STEP' command, example defined above are this type of jobs.
   • Single APPLY statement enclosed in job 'STEP' command
   • Multiple APPLY statement enclosed in job 'STEP' command
   Sometime it is required to execute commands in sequence i.e. some steps prior to some other steps. Example:table should be dropped first before recreation the table.
   Syntax: Single APPLY with single 'STEP'
   Syntax: Single APPLY with multiple 'STEP'
   
2. DEFINE OPERATOR: One or multiple type of operator/s are required to be defined in order to perform any operations in TPT.
   Available 'Define Operators' are listed below:

   Operator Type	Description
   DATACONNECTOR PRODUCER	This operator used as a producer to get data from source.
   DATACONNECTOR CONSUMER	This operator used as a consumer to push data to target.
   DDL	This is standalone operator for perfomring DDL/DML operation.
   EXPORT	Export operator works similar to Teradata FASTEXPORT.
   FASTEXPORT OUTMOD	FastExport OUTMOD Adapter operator works similar to Teradata FASTEXPORT OUTMOD.
   FASTLOAD INMOD	FastLoad INMOD Adapter operator works similar to Teradata FASTLOAD INMOD.
   INSERTER	Consumer operator that to insert data into given table.
   LOAD	Load operator works similar to Teradata FASTLOAD.
   MULTILOAD INMOD	MultiLoad INMOD Adapter operator works similar to Teradata MULTILOAD INMOD.
   ODBC	This operator allows to read data from ODBC compliant data sources.
   OS COMMAND	This is standalone operator for executing OS commands.
   SELECTOR	Producer operator to retrieve data from a given table.
   STREAM	Stream operator works similar to Teradata TPUMP.
   UPDATE	Update operator works similar to Teradata MULTILOAD.

   
   Syntax: Defining a operator in TPT
   Example: Defining a operator in TPT
   Note: For more detail on INMOD (Input modification) and OUTMOD(output modification), click here which will redirect to teradata site
   
3. DEFINE SCHEMA: This is used to describe the structure of the source dataset or target dataset. Each field definition will contain column name and its data type. One defined schema can be used to point multiple data objects.
   Syntax: Defining a schema in TPT
   Example: Defining a schema in TPT

This section describes how to connect Advanced Query Tool (AQT) to Exasol and run an SQL statement.

Environment

Following environment is used as an example:

• AQT evaluation version
• Windows Operating System

Prerequisite

• Exasol should be installed and running on your system.
• ODBC Driver should be installed. You can download the ODBC Driver from Exasol Download page. For more information about ODBC Driver, see ODBC Driver.
• AQT client should be installed and running on your system.

Procedure

1. Launch AQT.

2. Click Add new Datasource in the Other Tasks on the home page and select EXASolution Driver.

3. Set up the ODBC connection by providing the following details and click Test Connection:
   • Data source name: Exasol
   • Connection string: IP address of Exasol
   • User name and password: Username and password to login to Exasol. If it is a new installation, username is sys and the password is exasol.

4. After a successful test connection, the Datasource is added and shown in the Connect to a Database section.
   Enter Userid and Password to connect to Exasol.

5. After a successful connection, the database details are displayed in the left tree as shown below.

6. Click SQL icon in the toolbar to run an SQL statement. A blank window pops up.

7. Enter your SQL statement and click Run icon. The result of the statement is shown below.

Next Step

After connecting AQT to Exasol, you can start loading data into the Exasol database. For more information, see Loading Data.