TD Import Script Generator

Generate Teradata Import Scripts with just one click
(Saves ~95% man-hours)

Actual Screen Shot

Step 1 : Enter Required Details


Step 2: Click a button


Step 3: Copy Load Script and run in Teradata

Can I see the solution in action ?

Sure. Watch the video below to see quick demo of the utility in action.

This looks great. Can I test the solution before actually buying it ?

Yes please. Below is the web-version of the software. Give it a try now. If you like it, please leave a comment for us.

Click button below

To fetch Columnname , use below options:

Option 1: select columnname from dbc.columnsV where databasename='DummyDb' and tablename='DummyTbl' order by ColumnID

Option 2: help table DummyDb.DummyTbl and copy columnnames only

Save content in a file. eg: filename

To execute the script use below commands:

  1. bteq < filename
  2. fastload < filename
  3. mload < filename
  4. tbuild -f filename

How to use this Teradata Import Script Generator online ?

This tool helps you generate BTEQ Import, Fastload, Multiload and TPT Load script. Few inputs required from user :

  1. SERVER IP: Enter TDPID or Teradata server IP to connect. Default value is 'DummyIP'
  2. USERNAME: Enter username required to connect to TD. Default value is 'DummyUser'
  3. PASSWORD: Enter password required for username. Default value is 'DummyPassword'
  4. TABLENAME: Enter TABLE name along with DATABASE name. Default value is DummyDb.DummyTbl
  5. FILENAME: Enter data file name with path. Default value is 'Filename.txt'
  6. Max String Length: This should be set to maximum string length for any column which you are passing. Default value is 400 so columns will be 'varchar(400)'
  7. Delimiter: Pass the delimiter used in the file. Default value is '|'
  8. Column list: Enter column names from the table to which data file is to be imported. Enter one column name per line.

Assumptions

Few assumptions made to keep things simple here:

  1. Dummy values are mentioned above. If you are not giving any input then please remember to update the "Dummy" values with actual before executing the script.
  2. Column list is mandatory and user have to provide one column per line. To fetch the column list, 2 options are also mentioned above. Either by running SQL query or by running HELP command. Copy and paste the column list in the textbox. Example, you want to give 4 columns of EMPLOYEE table then you will pass values like:
    EMP_ID
    EMP_Name
    EMP_Age
    Emp_Salary
  3. FILENAME: You can pass absolute data file path as well. However for TPT Load , you may want to use DirectoryPath variable to set path.
  4. Once code is generated and "dummy" value (if applicable) is modified, save the content into a file and name it as per your wish.
  5. To execute the code , use respective command mentioned below:
    bteq < filename
    fastload < filename
    mload < filename
    tbuild -f filename

The inspiration behind creating this utility is I get so many request regarding loading data files into Teradata tables. So the people who are not usual Teradata developer however they have basic understanding of SQL , often struggle to write these scripts. Also writing scripts is not complex however it may take some time. Hence to save time and help others who just want some data into Teradata table I have created this utility. You may want to change some variables as per your requirement. The code above is primarily to load empty tables. Hope it helps.

Check the video below for the web-version of Teradata Import Script Generator.

When I can use web version for free then why will I buy desktop version ?

We are happy that you are finding web version useful. You can continue to use web version as you wish. We will list down 2 primary reasons why we think using desktop application is better option :

  1. Your Information is secured: The information you shared like login credentials and table details will remain in client network only. Though we don't save any such info in web version as well but the info is processed over internet. Desktop version provides better security. While using web-version you can also leave information like password as "blank" which will be defaulted to "dummy" and then you can replace the value once it is generated.
  2. Much Quicker and Less Manual work: In desktop application , you don't have to supply column names list. This definitely saves time. Also you don't have to change "dummy" values in desktop version. You can use actual values and run the output generated from desktop itself.

This is fantastic. How can I download the software and use it on my local machine ?

Download the software now from the below link.

*First 50 customers can use discount code (TD100OFF) to get it for FREE.

4 thoughts on “TD Import Script Generator”

  1. I have loved using this tool, it seems that the website has been reconfigured and now I cannot find the td import script generator. This page only has instructions, but no actual generator.

    1. Thank you Kai for leaving a comment and informing us that something is not working.
      We have fixed the issue and now you can use the tool.

      Best,
      Raj

      1. Raj, I miss this tool! Please add it back. People complaining about entering their credentials don't need to! Just change it after copying and pasting the script into a local file.

Leave a Reply

Your email address will not be published. Required fields are marked *