Search code examples
oracle-databasepostgresqletltalend

How to create configuration to specify Source(DB) and Destinations dynamically in Talend?

I have to move data from Oracle to PostgreSQL on Amazon cloud. I want to know if there are any ways to take care of configuration related issues.I want to take connection string ,userID, password and other credentials dynamically.How am I supposed to do this ?

Solution

  • You can use tFileInputProperties component for that. There you can set the type of the configuration file (.properties or .ini) and the path of the configuration file. The output is a key value pair row. Connect it with tContextLoad. If the key in the configuration file is the same as the context variable name, then it will set the value.
    Here is the overview of the .properties file structure: https://en.wikipedia.org/wiki/.properties
    And here is the .ini file structure: https://en.wikipedia.org/wiki/INI_file