Generate Teradata Import Scripts with just one click
(Saves ~95% man-hours)
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.
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:
- bteq < filename
- fastload < filename
- mload < filename
- 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 :
- SERVER IP: Enter TDPID or Teradata server IP to connect. Default value is 'DummyIP'
- USERNAME: Enter username required to connect to TD. Default value is 'DummyUser'
- PASSWORD: Enter password required for username. Default value is 'DummyPassword'
- TABLENAME: Enter TABLE name along with DATABASE name. Default value is DummyDb.DummyTbl
- FILENAME: Enter data file name with path. Default value is 'Filename.txt'
- 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)'
- Delimiter: Pass the delimiter used in the file. Default value is '|'
- 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:
- 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.
- 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 - FILENAME: You can pass absolute data file path as well. However for TPT Load , you may want to use DirectoryPath variable to set path.
- Once code is generated and "dummy" value (if applicable) is modified, save the content into a file and name it as per your wish.
- 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 :
- 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.
- 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.
6 thoughts on “TD Import Script Generator”
The fastload script appears to work but then after it completes I get an error saying that the tables are being loaded and they are locked. I cannot release the locks. Even the error tables are locked.
Hi Chris,
This is default behavior of FASTLOAD script.
Whenever it fails, it locks the table. The reason is to add resume capability in case of failures.
You can just drop- recreate the target table & drop the error tables.
Fix your fastload script or data file and run the job again.
If you need any more assistance , send me an email at nitin@etl-sql.com
Best,
Nitin Srivastava
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.
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
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.
Hi Kai,
I have reverted the changes.
Hope this helps.
Cheers,
Raj