How should you configure the tDBInput components?

You built multiple Jobs in Studio, each uses its own tDBInput component to connect to a common database server, but they all use different credentials.

How should you configure the tDBInput components?
A . Set the Property type to Repository and replace the credential1; in each component.
B . Set the Property type to Built-in and set all the relevant properties manually.
C . Set the Database file to Metadata
D . Set the Property type, to Repository and use a common DB connection metadata

View Answer

Answer: B

Explanation:

The tDBInput component allows you to configure the connection properties either by using a built-in mode or by using a repository mode. The built-in mode lets you set all the relevant properties manually, such as host, port, database, username, password, etc. The repository mode lets you reuse an existing connection metadata that is stored in the repository. If you have multiple jobs that use different credentials to connect to a common database server, you should use the built-in mode and set the properties for each job individually. This way, you can avoid creating multiple connection metadata in the repository and maintain them separately.

Reference: Talend Data Integration ― Software to Connect, Access, and Transform Data | Talend, [tDBInput properties – 7.3]