DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17

Thread: Accessing different databases through XML

  1. #16
    Sylvia Vargas Guest

    Re: Accessing different databases through XML


    If you really want to use XML to transport between ORACLE and SQL Server,
    ORACLE has tools in JDeveloper to extract/import XML DTD (not XML Schema).
    I believe that MS SQL Server has Extraction tools also.

    Just make sure that the XML you extract from MS/SQL Server is DTS not Schema.

    Sylvia

    "James Dooley" <james@siteknowhow.com> wrote:
    >You can actually link MS SQL server directly to Oracle using 'Linked
    >Servers'
    >and avoid the whole issue.
    >
    >Regards,
    >
    >James.
    >
    >"Latha Sudharshan" <sudharsh@pacbell.net> wrote in message
    >news:39cd9274$1@news.devx.com...
    >>
    >> Hi,
    >>
    >> I am a bit new to XML. I was wondering about a problem of server-database
    >> interaction. My problem goes like this:
    >>
    >> Say, I have two databases - Microsoft SQL (say, on Host1) and Oracle 8i

    >(on
    >> Host2) and the hosts are distributed. I am thinking of exchanging the

    data
    >> through an XML document.
    >>
    >> Now, Host1 needs to access data from Host2(i.e., from Oracle 8i) and store
    >> that data into it's local database (i.e., SQL). In this case, Host1 is

    >acting
    >> as client and the server has to withdraw data from Host2's database.
    >>
    >> This needs client-side processing too I guess.
    >>
    >> My question is how do I do this. I have gone through some books and I

    >sense
    >> that I need to use DOM or SAX parser on the server side so that I don't

    >have
    >> to write database-specific queries to query or insert data into the

    >database.
    >> Is that right? Also, is there anything else I need to use on the

    >server-side?
    >> I just don't get the big or the small picture of proceeding further.
    >>
    >> How do I go from here? If anybody has any idea, please let me know.
    >>
    >> Thanks in advance.
    >> -Latha
    >>
    >>

    >
    >



  2. #17
    Baasima Guest

    Re: Accessing different databases through XML


    Jeff will u please tell me from where i get iConnector in detail


    "Jeff" <jtodd@infoteria.com> wrote:
    >
    >If your application is more than a one time, or very infrequent sharing

    of
    >information between the servers, you might want to consider a commercial
    >tool from Infoteria. One of the tools, called iCONNECTOR converts back

    end
    >relational data to XML. It's bi-directional and will convert XML and put
    >it in the database as well. There are connectors for SQL, Oracle, DB2,

    Notes,
    >and Access. There is a utility in the product that allows you to generate
    >and save a rule file. The rule generator has a graphical UI that allows
    >you to select a table from your db and point to the fields you want to map
    >to your XML tags, or from your XML tags to your fields. This ensures your
    >mappings don't break or are inadvertently changed.
    >
    >They are not cheap, but used with the iMESSENGER product, which can automatically
    >rout your XML file via SMTP, you can build a robust automated system that
    >extracts Oracle, converts to XML, sends, receives, converts to SQL and inputs
    >to the right fields and tables - and go back the other way if you wish.

    Hope
    >this helps.
    >
    >Jeff Todd
    >978 922-4029 x137
    >www.infoteria.com
    >
    >
    >"Latha Sudharshan" <sudharsh@pacbell.net> wrote:
    >>
    >>Hi,
    >>
    >>I am a bit new to XML. I was wondering about a problem of server-database
    >>interaction. My problem goes like this:
    >>
    >>Say, I have two databases - Microsoft SQL (say, on Host1) and Oracle 8i

    >(on
    >>Host2) and the hosts are distributed. I am thinking of exchanging the data
    >>through an XML document.
    >>
    >>Now, Host1 needs to access data from Host2(i.e., from Oracle 8i) and store
    >>that data into it's local database (i.e., SQL). In this case, Host1 is

    acting
    >>as client and the server has to withdraw data from Host2's database.
    >>
    >>This needs client-side processing too I guess.
    >>
    >>My question is how do I do this. I have gone through some books and I sense
    >>that I need to use DOM or SAX parser on the server side so that I don't

    >have
    >>to write database-specific queries to query or insert data into the database.
    >>Is that right? Also, is there anything else I need to use on the server-side?
    >>I just don't get the big or the small picture of proceeding further.
    >>
    >>How do I go from here? If anybody has any idea, please let me know.
    >>
    >>Thanks in advance.
    >>-Latha
    >>
    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center