You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Enterprise Data Integration » General questions
- » Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL
#1 2011-10-31 09:18:58
- esalayon
- New member
- Registered: 2011-09-12
- Posts: 8
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
Offline
#2 2011-11-01 03:13:55
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
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#3 2011-11-01 03:30:16
- esalayon
- New member
- Registered: 2011-09-12
- Posts: 8
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
Offline
#4 2011-11-01 07:39:43
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
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#5 2011-11-01 08:44:24
- esalayon
- New member
- Registered: 2011-09-12
- Posts: 8
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
Offline
#6 2011-11-01 09:04:28
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
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#7 2011-11-01 09:20:04
- esalayon
- New member
- Registered: 2011-09-12
- Posts: 8
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?
Offline
#8 2011-11-02 02:41:02
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
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
Pages: 1
- Index
- » Talend Enterprise Data Integration » General questions
- » Talend CDC using Oracle LOGS (LogMiner) as Source and Target is MS SQL