Which steps should you take before building a Job that reads from that database?

You need to create a centralized metadata connection to database server for an application.

Which steps should you take before building a Job that reads from that database? Choose 3 answers
A . Add a tMap component handle and convert DB Types.
B . Retrieve schemas from the database connection.
C . Drag the Db Connection metadata into the Designer to read from the database component.
D . Create DB Connections metadata to describe the database connection.
E . Add a tCreatTable component to create a table in the database.

View Answer

Answer: B, C, D

Explanation:

To create a centralized metadata connection to a database server for an application, you need to take the following steps before building a job that reads from that database:

Create DB Connections metadata to describe the database connection. You can do this by right-clicking on the DB Connections node in the Repository and selecting Create Connection. You can then enter the connection details, such as host, port, database, username, password, etc., and test the connection.

Retrieve schemas from the database connection. You can do this by expanding the DB Connections node in the Repository and right-clicking on the connection you created. You can then select Retrieve Schema and choose the tables or views you want to import as metadata schemas. You can also edit or customize the schemas as needed.

Drag the DB Connection metadata into the Designer to read from the database component. You can do this by dragging the connection or a specific schema from the Repository to the Designer workspace. This will automatically create a database input component (such as tMysqlInput) that is configured with the connection and schema properties. You can then use this component to read data from the database in your job.

You do not need to add a tMap component to handle and convert DB Types, nor a tCreateTable component to create a table in the database. These components are not required for reading data from an existing database, but they can be used for other purposes, such as transforming or writing data.

Reference: Talend Open Studio: Open-source ETL and Free Data Integration | Talend, [DB Connections – 7.3], [tMap properties – 7.3], [tCreateTable properties – 7.3]