The Definitive Guide to Data Quality
Does a CDC database need to be installed prior to using tMySQLCDC component in jobs?
When I hit 'Log In' at the top right hand corner of Talendforge page, it then shows my userID - lenfinkel (View/Edit mode). But when I go to view posts, do a search, etc... the msg at the top (right under Index, Tags, Timeline, etc... says "You are not logged in'. Is this a bug? What is the next step to be able to upload images?
Please advise. Thank you.
Is it only a matter of simply creating a database and that is it?
So you are saying that I do need to create a CDC database to be able to use CDC component in a job - it is required, right? I have seen the tutorial that you have provided - thank you. However, it does not specify what type of schema, tables, etc. needs to be created in the "CDCOracle" database. Is it only a matter of simply creating a database and that is it? If not, could you please provide more specific details? As of now, I still do not know what exactly needs to be done to be able to run a job using CDC components.
Could you please send me demo job you explained above.
Sorry for the delay. For your confusion, i have create a demo job using mysql DB to explain how to use the CDC connenction .
Step 1: Populating a data warehouse
The following Java scenario creates a three-component Job that populates a data warehouse. A tMysqlInput component reads your test data stored in the test base. A tMap component allows you to modify this data and the modifications are transmitted to the crm table in the CRM database through a tMysqlOutput component.
Drop the following components from the Palette onto the design workspace: tMysqlInput, tMap, and tMysqlOutput.
Connect the three components using Row Main links. see pic1
In the design workspace, select tMysqlInput and click the Component tab to define its basic settings. pic2
Set Property Type to Repository and then select the connection to the test database that holds the information about your clients. The connection details will display automatically in the corresponding fields.
If you have not stored the DB connection details in the Metadata entry in the Repository, select Built-in in the property type list and set the connection details manually.
Set Schema to Repository and click the three-dot button to select the schema of the test database stored in the Metadata entry.
In the Table Name field, enter the name of the table holding the information you want to modify, in this example: test
Click Guess Query to retrieve all data from your table.
Double-click the tMap component to open the Map Editor. Notice that the Input area is already filled with the metadata of the input component. pic3
drag the fields in the input zone to the fields in the test table in the output zone. For more information regarding data mapping
Click OK to validate the operation.
In the design workspace, select tMySqlOutput and click the Component tab to define its basic settings.pic4
Waiting, i will send the step 2 and step3