Results 1 to 5 of 5

Thread: schema mapping

  1. #1
    Join Date
    Jun 2009
    Posts
    2

    Question Unanswered: schema mapping

    hi,
    my app requires getting data from a customer's database into mine and manipulating it. The challenge is different customers have their data in different databases (Oracle, mysql, DB2, sqlserver,etc) and in different formats(schema's). For each customer, I need to create a mapping of the schema elements between the customer database and mine.

    I am imagining some kind of a visual tool to show the two databases metadata side by side and allow you to define the mapping manually -- but I am not sure if such a tool exists.

    Have a couple of questions -
    1. What approach would you take to address the above problem?
    2. Are you aware of any tools which would help me in this process?

    Thanks in advance,
    duby

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074
    Visio can reverse engineer an ERD, as long as you have ODBC connectivity.
    --=cf

  3. #3
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    I'd suggest using an integration tool to develop the whole process. Any number of integration tools will let you create and execute such transformations. Most let you map source to target in some kind of visual development environment. Your budget will be a factor because these solutions tend to be pricey.

    For example:

    Data Integration - Informatica
    IBM - data integration, connectivity, scalable platforms - IBM InfoSphere DataStage - Software
    SQL Server Integration Services
    Pervasive Software - Data Integrator: Data Integration Software

  4. #4
    Join Date
    Jun 2009
    Location
    Alabama, USA
    Posts
    1

    If money is an issue...

    Consider open source as well:

    Pentaho

    Talend

    Apatar

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Try Oracle Data Integrator - it is free.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •