Type tree creation using ITX Database Interface Designer

IBM Transformation Extender (ITX) is one of the most powerful data transformation product and its supportability of multiple protocols and routing capabilities has made it a unique product delivering flexibility in IT systems, resulting in business agility.It has the ability to transform any type of data to any specific format with formats including XML,Non XML, Cobol Copybook,EDI and many others. With IBM’s latest offering of additional industry packs for healthcare and finance industry, the complexity of development has been further reduced, resulting in quick return on investment.

The current version of ITX is v9.0, previously ITX was named Websphere Transformation Extender (WTX) and prior to it as Mercator. To create the maps for transformation the input and output objects needs to be converted to a type tree.

In this blog post, you will learn how to create a type tree for a table in a database using IBM Transformation Extender Database interface designer tool. For easy understanding, I have provided screenshot of each step involved in the creation of type tree and the database used for this example will be Microsoft SQL Server 2014 database.

Step 1 :

Login to the Microsoft SQL server 2014 database with a valid credential which has access to the create database and tables.

Step 2:
Create a table or select the name of the table for which the type tree needs to be created. In this example we will create the type tree for the table ”EMPLOYEE” placed in the database “EXAMPLECORPS”.

Step 3:
Launch the Database Interface Designer application.

Step 4:
Create a new database/query file.

Step 5:
Create a new database connection.

Step 6:
Enter the database name and select the adapter type as MS SQL Server.
Note: The database name necessarily doesn’t have to be the exact name of the database but it’s a good practice to have it as the exact database name.

Step 7:
Fill the security information with a valid username and password, enter the name of the SQL server and select the appropriate database. In this example the database to be used is “EXAMPLECORPS”.

Step 8:
Review the database connection and press OK to create the database component in Database Interface Designer.

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

Step 9:
In the table component, right-click and select Generate tree option.

Step 10:
Select the table for which the type tree needs to be created. Our focus for this example is to create type tree for the table “EMPLOYEE”, so select the “EMPLOYEE” table.

Step 11:
Enter the folder location in which the type tree file needs to be saved.

Step 12:
Click generate option to create the type tree.

Step 13:
The type tree is created now and placed in the folder which was set as the target. Next we can load and verify the type tree created using ITX Design Studio.

Step 14:
Launch the Design studio application from the list of programs.

Step 15:
Create a new Extender project.

Step 16:
In the type tree folder, right-click and import the file.

Step 17:
Select the .mtt file from the location in which the type tree was created. In our example the type tree created using database interface designer is placed in C:\IBM

Step 18:
Select the extender project name in which the type tree needs to be imported for the Into folder field.

Step 19:
Select the type tree imported to the project to view the structure.

This completes the steps involved in creation of a type tree from a database table.

References:

Click to access sg247693.pdf

http://www-03.ibm.com/software/products/en/transformation-extender