Forum Discussion

Szymon's avatar
Szymon
New Contributor II
5 years ago

Dynamic File Writer filename after XML Formatter possible?

Hello, Is there a simple way, to pass filename to File Writer, after XML Formatter was executed? In the Mapper: filename shall be constructed into $filename. XML JSON content for saving als...
teradata
rakesh_2004's avatar
rakesh_2004
New Contributor
6 years ago
Copy LinkReport

Thanks for the details. Did you pass the parameters from pipeline parameters? I have cretaed a parent pipeline where i have read the parameters from a file and then passing them to child pipeline where i have the MySQL execute snap. In the account tab of My SQL execute i want to create a connection dynamically by using the parameters coming from parent pipeline which are coming from the file.

rakesh_2004's avatar
rakesh_2004
New Contributor
6 years ago
Copy LinkReport

I tried it access pipeline parameters where i have host name , port name , db name, user and password but the parameters are not available when i am trying to create the Dynamic connection. Any help will be very much appreciated.

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    4 years ago
    Copy LinkReport

    Hi @Jarek,

    This sounds like a Collation issue. Check if there’s a Url setting added in the account you are using in the JDBC snaps.

    • Jarek's avatar
      Jarek
      New Contributor
      4 years ago
      Copy LinkReport

      Hi @bojanvelevski

      This is what I have in the account settings. Is there a way to add e.g. UTC format or something similar?

      jdbc:teradata://tdwd/TMODE=ANSI,CHARSET=UTF8

      BR,
      Jarek