Skip to Content
author's profile photo Former Member
Former Member

Bulk Loader Option are not available (Data Integrator Designer)

Hi to all.

I'm using Data Integrator XI 3.1 with TD release 12.

The problem is that the Bulk Loader option for Teradata are not available to be used.

The Teradata client 12 is fully installed (ODBC, Stand alone utilities (fastload, multiload...), named pipe and Teradata Parallel Transporter).

Do you have some suggestions? Why the designer 'cannot see' the bulk loaders?

Thank you in advance


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 07, 2010 at 08:08 PM

    what is the Datastore Database type set to ? Teradata or ODBC ? set this to Teradata if its ODBC

    is Target Table in Datflow Template Table ? this should be regular table not template table

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      you need bulk load utility at run time not at Desgin time, and yes they should be available on job server Machine

      when creating a DF in Designer, you need connectivity to Teradata, to import the tables once the tables are imported you can use them as target and set the bulkloader, type and options click on the Bulk Loader tab for taget, and from the drop down list select the bulk load type and set the parameters by default its none

      are you not seeing th Bulk Loader tab or Bulk Load dropdown list ? Designer will not check for availability of bulk load utilities

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.