LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Using DB Query to pull from Teradata db

    Employee
    Posted 12-22-2015 12:32

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: JAWILBUR

    Hi

    I am trying to use a DB Query node to pull from a Teradata database.

    What should be the dbService and dbInterface?

    Thanks


  • 2.  RE: Using DB Query to pull from Teradata db

    Employee
    Posted 12-22-2015 12:57

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mmarinelli

    Hello -

    DbInterface should be set to CLI, signifying a Teradata connection
    DbService should be set to the host name of the database to which you want to connect

    You may have to provide a fully qualified host name (e.g. foo.bar.com) rather than just the machine name (e.g. foo), depending upon your network configuration


  • 3.  RE: Using DB Query to pull from Teradata db

    Employee
    Posted 12-22-2015 13:09

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: JAWILBUR

    Hi

    I made the changes but get the error attached.

    NDWError.jpg


  • 4.  RE: Using DB Query to pull from Teradata db

    Employee
    Posted 12-22-2015 13:41

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mmarinelli

    It looks like the host name that you provided is not listed in your local configuration. If you are working on the desktop, that would mean that your personal PC is not configured to access the Teradata server. If you are connecting to a Lavastorm server, then that server is not configured to access the Teradata server. The best route would be to connect to Teradata using another tool, and ensure that the configuration parameters of that tool contain the same values as your Lavastorm database node.


  • 5.  RE: Using DB Query to pull from Teradata db

    Employee
    Posted 12-22-2015 13:54

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: JAWILBUR

    See attached for my Teradata ODBC setup

    I can log on and query using the Teradata client no problem, I am using a Desktop server.

    NDWError2.jpg


  • 6.  RE: Using DB Query to pull from Teradata db

    Employee
    Posted 12-22-2015 14:44

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mmarinelli

    So when you set the DbService to either the IP address or the machine name shown in your screenshot, you cannot connect?

    If that is the case, it may be better to use ODBC as a connection method, so you would use the following parameter values:

    DbInterface set to ODBC
    DbService set to PROD

    If neither option resolves your problem, I would suggest reaching out to Lavastorm support, who can dig deeper and work with you to resolve configuration issues.


  • 7.  RE: Using DB Query to pull from Teradata db

    Employee
    Posted 12-24-2015 07:39

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: JAWILBUR

    Great. thanks for the help the last solution worked to connect