We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Inner join on output to pull data from different table

Comments

3 comments

  • Avatar
    Adrian Williams

    The JDBC Query node allows you to create a parameterized SQL query where one or more elements can be obtained from field values in the input data. The element(s) to be parameterized are represented in the SQL query using the '?' character and the corresponding input field(s) are listed in the SqlQueryFieldBindings property e.g.

     

    Also, from Analyze v.3.5.0 the JDBC Query and JDBC Execute nodes were enhanced to support the use of dynamic SQL where the SqlQuery property could be obtained from an input field, e.g. 

    0
    Comment actions Permalink
  • Avatar
    Marzena

    I forgot to add, the source of data for table A would be Teradata, not SQL.  

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Teradata provide a JDBC Driver:

    https://downloads.teradata.com/download/connectivity/jdbc-driver

     

    You should review the Help topic for the JDBC Query node (Note help > Input Connectors > JDBC Query). 

    In particular you will need to review the information on the placement of driver jar files cnd classpath configuration that is discussed in the 'Advanced database connection' section of the Help.

     

    The DB Query node does not support an input pin so gou cannot parameterize the query in the way possible using the JDBC Query node. 

    0
    Comment actions Permalink

Please sign in to leave a comment.