One Star

Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Hi,
The scenario is like this:
The source is Oracle 8i, and want to use the log technique (Not the trigger) for this CDC implementaion, using the LogMiner utility of the DB. The target DB would be MS SQL Server 2008. Would this be possible, out of the box (since it is two different DBs)?
Kind regards,
Eric
9 REPLIES
Community Manager

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Hi Eric
You are able to choose 'Log mode' option when you create the Oracle CDC. see my screenshot.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Thanks for the reply Shong.
But how does Talend CDC does it? I mean, does it uses the LogMiner? Hope you have a sample demo for this. Also, as I've mentioned, does it support the source of the CDC is Oracle 8i and the target db is MS SQL Server out of the box?
Kind regards,
Eric
Community Manager

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Hi Eric
CDC technique was introduced in Oracle 9i version onwards, hence Talend CDC does not support the source of the CDC is oracle 8i.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Hi Shong,
Oh, I didn't know that. Thanks for the info.
So the Trigger is the best suited technique for Oracle 8i. How about the Oracle to MS SQL CDC implementation, will these be done out of the box?
Many thanks,
Eric
Community Manager

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Hi
CDC implementation is applied to the source database, Oracle is the source database in your case. What do you mean out of the box?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Since my target db (MS SQL) is different from the source (ORACLE), can it convert SQL statement coming from ORACLE (may have oracle specific SQL) to MS SQL accepted sql statement?
Community Manager

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Hi
There are different components for different database type, for example, tMSSQLOutput is used to execute MS SQL sql statement for inserting, updating and deleting, tOracleInput, tOracleCDC is used to query records from Oracle database. There is a middle type for converting db type from one to one in Talend, hence don't care for the converting of SQL statement.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Hello all
I am new to talend. I have a scenario..    I want to  load data from flat file to Oracle database incrementally.
(e.g I have 10 rows in flat file in initial load all 10 records are inserted.
(Now source flat file)  5 rows are added to flat file , now it has 15 rows.
If we run the Job again we need to insert newly added rows only (to database).
How to achieve this....
Thanks & Regards
Varma
One Star

Re: Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL

Hello all
Please help me for the scenario
Inserting records into Target table using Lookup.
(lookup source is Taget Table)
Using lookup condition I want check the records are exists in the target or not. If not then insert.
Thanks & Regards
Varma