DB2 Information Integrator and Oracle Spatial

Posted on 2006-04-25
Last Modified: 2012-06-27
We have Oracle Spatial installed and its being used by an application. I guess spatial feature is just a add-on to standard oracle database.

Can I use DB2 Information Integration to access data (and write back too) in Oracle Spatial ?

If yes, will I need DB2 Spatial extender as well ?

Question by:sachinwadhwa
    LVL 45

    Expert Comment

    Hi sachinwadhwa,

    Bad news.  Oracle Spatial is a proprietary product that has no equal in the DB2 world.  If you're going to port your Spatial application to DB2 you've got a fair amount of work ahead of you.  And I'm unaware of a DB2 Spatial extender product.  You'll have to be somewhat creative.

    Good Luck!
    LVL 7

    Author Comment

    Hi Kent

    here is the link for DB2 spatial extender:

    and Information Integrator:
    LVL 45

    Expert Comment

    Hi sachinwadhwa,

    Wow.  That's news to me.  :)  Learn something every day, huh?  Oracle has such a huge share of that market that I didn't even recognize IBM as a player there.

    LVL 2

    Expert Comment


    Accepted Solution

    Closed, 250 points refunded.
    The Experts Exchange
    Community Support Moderator of all Ages

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now