Friday May 04, 2012

Migrating DB2 z/OS to Oracle Database

I have been receiving many requests for information on migrating IBM z/OS DB2 databases to Oracle so I thought this would be a great topic.
Third Party Tool Solutions
1.Ispirer- Ispirer - I have worked with there tool before and it is solid. They offer services as well.

Third Party SI Providers (with their own tools)
1.Prac Trans - Prac Trans - I have worked a lot with this company. They have both internal tools to migrate db2 z/OS and very skilled mainframe DB2 resources.

Oracle Solutions
A. Oracle ART Tuxedo Workbench - Oracle ART Workbench
Note: This costs minimum of $80K for two developer licenses.
Solution is disk to disk based.
B. Oracle Warehouse Builder - Free Oracle database ETL tool. You would use JDBC as listed here:
OWB
OWB supports importing of COBOL copybooks where DB2 tables are often defined. NOTE: JDBC connection to mainframe DB2 can be slow.
Solution can be disk to Oracle DB or DB2 to Oracle (stream based).
C. Oracle DRDA Gateway - Connect to DB2 on mainframe from Oracle and use Select statements to migrate (nothing to install on mainframe) Oracle DRDA Gateway
Solutions is stream based/disk less.
D. Oracle Data Integrator - No DB2 Knowledge built for DB2 mainframe but one could be developed.

Thursday Aug 11, 2011

Oracle Integration Products

Keeping with the theme of integration. Check out this article I just wrote that is published here: http://www.packtpub.com/article/oracle-tools-products?utm_source=oracle.com&utm_medium=link&utm_content=agency&utm_campaign=mdb_009140&utm_source=Oracle+Employees&utm_campaign=40955e40ec-Packt_s_Oracle_Employee_Newsletter_August8_10_2011&utm_medium=email&mc_cid=40955e40ec&mc_eid=d3eb770bcf

Saturday Jun 04, 2011

Legacy Data migration and Integration using Oracle Data Integrator

Oracle Data Integrator can be used to migrate, consolidate and integrator your legacy data stores to an Oracle Database. A white paper can be found here: http://www.oracle.com/us/products/middleware/059481

Sunday May 08, 2011

Oracle Information Integration and Data consolidation 'in the cloud'

I have a new book coming out with a couple of coworkers. It can be found here in raw format:http://www.packtpub.com/oracle-information-integration-migration-and-consolidation/book Information integration and data migration in the cloud is an area that is new in cloud deployments. The appendix/futures section of this books discusses information integration, data migration and data consolidation in the cloud.
About

Migrating legacy client/server and mainframe technologies to the Oracle cloud.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today