[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dec_data_distributor

Title:The Replication Option for Rdb
Notice:Product renamed to Replication Option for Rdb
Moderator:BROKE::PROTEAU
Created:Wed Mar 02 1994
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:287
Total number of notes:1231

225.0. "Replication to Oracle on Unix?!" by itvms1.it.oracle.com::ITOTA () Tue Jul 02 1996 12:54

	Hi,

	I've a question about data replication to Oracle RDBMS.

	I read on DDAL 6.1 handbook that replication on Oracle
	has DBIntegrator Gateway for Oracle as prerequisite but
	"Oracle database resides on VAX or ALPHA processor running
	Openvms operating system".

	I read also note 92 on this conference, that had some questions
	about data replication to Oracle running on Sun Unix.

	My customer need to replicate data from RDB on VAX to 
	Oracle running on UNIX.
	Is it possible in a way?

		Thanks a lot in advance,


				Ivo Tota
	
				Turin,	Italy
T.RTitleUserPersonal
Name		DateLines
225.1SupportedBROKE::PROTEAUJean-Claude ProteauTue Jul 02 1996 17:4813
    Ivo,
    
    DDAL 6.1, which is now called the Replication Option for Rdb version
    7.0, should work as you desire.  That is, we do support replcating Rdb
    data from a VMS system to an Oracle Rdbms on a non-VMS system.  Note 92
    talks about a problem we used to have in both SQL and Data Distributor. 
    Both would take username and password and convert them to uppercase. 
    This is no longer done.  There were also some issues about installing
    the Oracle gateway images.  That's just a matter of knowing which
    images need to be installed and adding commands to a startup file if
    necessary.
    
    Claude
225.2Thanks Claude144.24.1.1::ITOTAThu Jul 04 1996 04:2418
	Thanks a lot, Claude.

	I'll give the right info to the customer.

	Anyway, software prerequisite to replicate RDB data to
	an Oracle RDBMS on unix are:

		DDAL 6.1 ( RDB 7.0 replication option )
		DBI
		DB INTEGRATOR GATEWAY FOR ORACLE

	Am I correct?

	Thanks a lot another time,


				Ivo
225.3Not quite rightBROKE::PROTEAUJean-Claude ProteauThu Jul 04 1996 18:5423
    
    Ivo,
    
    This is what the customer needs:
    
    If the customer uses names and passwords that include some lowercase
    alphabetic characters and some of those names appear within the CREATE
    TRANSFER statements, the customer will need:
    
    	Replication Option for Rdb version 7.0
    	Transparent Gateway for Oracle version 7.0
    
    Note that DBI itself (the Parallel Query Option ...) is not required.
    Only the Oracle Gateway is needed.
    
    If all strings that must remain in lower or mixed alphabetic case is
    hidden from the CREATE TRANSFER statement, then one ought to be able
    to use the current shipping versions:
    
    	Replication Option for Rdb version 6.0-11
    	Transparent gateway for Oracle version 3.1 (I think that's the one)
    
    - Claude
225.4OopsBROKE::PROTEAUJean-Claude ProteauThu Jul 04 1996 18:563
    
    ... and if all the strings "is" hidden, then I had better go back and
    relearn my English grammar!