Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: Automated data process


    What I want to do is trying to understand the options for getting data out of an SQL server database and into a DB2 database.

    The SQL Server database is behind the company's firewall.
    We need to get some data from there onto the new website. This has to be an automated process.

    There are two parts to the problem. Exporting the data and getting it to the web site. It has to be automated.

    This could be via some automated task doing an extract every night and sending it to the web server some how.

    I need to know & understand how it can be done. We are working in IBM Websphere environment.

    Thank you

  2. #2
    Join Date
    May 2003
    I am not sure exactly what you want, but you might look at Federated Database support in DB2. Check out the "Federated Systems Guide" (db2fpe80.pdf on the IBM web site).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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