Skip to Content
author's profile photo
Former Member

DB Connect to Progress DBMS

Hi, I am totally new to BW so apologies if this is a daft question or I use duff terminology!!!! I am just trying to get my head around BW to get a high level way forward!

I would like to connect BW to a Progress DBMS Database using DB Connect to extract some data to use in queries but according to help.sap.com Progress is not a supported Database. Anybody know any different to this?

If this is so, is there any better way of importing this data into BW than extracting data into a .csv from Progress and then importing this .csv into BW????

Many Thanks for any help or direction you can give!

Regards

Simon

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • May 05, 2004 at 03:26 PM

    hey simon;

    you may want to dial-in to a presentation happening right now about Universal Data Integration -- in BW 3.5, we've introduced a component called UD Connect, which is similar to DB Connect, but supports various non-SAP data sources through a set of BI Java Connectors. it sounds like you might be interested in the BI JDBC Connector for this purpose.

    if you can, dial-in now and ask your questions - details posted below.

    thanks,

    -m

    SAP NetWeaver Know-How Network Webinar:

    SAP BW Universal Data Integration

    Wednesday, May 5, 2004

    8 a.m. PDT • 11 a.m. EDT • 4 p.m. BST • 5 p.m. CEST

    On Wednesday, May 5, Oliver Mayer, SAP BI Platinum NetWeaver RIG Consultant, is hosting the webinar entitled SAP BW Universal Data Integration as part of the ongoing SAP NetWeaver Know-How Network Webinar Series.

    Here’s how Oliver describes his webinar presentation:

    "Universal Data Integration (UDI) is new SAP BW 3.5 functionality allowing you to seamlessly access non-SAP as well as SAP data. We will cover the two components of UDI: Universal Data Connect utilized from within the BW system to access remote data and the BI Java Software Development Kit (SDK) used for building custom applications."

    SDN invites you to post your questions to the presenter prior to the webinar and continue the online discussion afterward.

    Dial-in Information:

    Date: Wednesday, May 5, 2004

    Time: 8 a.m. PDT • 11 a.m. EDT • 4 p.m. BST • 5 p.m. CEST

    Within the U.S., call: +1.888.428.4473

    Outside the U.S., call: +1.651.291.0618

    Password: NetWeaver04

    WebEx Information:

    Topic: SAP NetWeaver Know-How Network

    Date: Wednesday, May 5, 2004

    Time: 8 a.m. PDT • 11 a.m. EDT • 4 p.m. BST • 5 p.m. CEST

    Meeting Number: 742391500

    Meeting Password: netweaver04 (lowercase)

    WebEx Link: sap.webex.com

    Replay Information:

    A recorded replay of this call will be available for approximately three months after the webinar. Access this recording by dialing the appropriate number and using the replay access code 720139.

    Toll-free: +1.800.475.6701

    International: +1.320.365.3844

    About the SAP NetWeaver Know-How Webinar Series

    The SAP NetWeaver Know-How Webinar Series is driven by the SAP NetWeaver Regional Implementation Group (RIG), part of the SAP Development organization. The mission of the SAP NetWeaver RIG is to enable customers, employees, and partners to successfully implement the SAP NetWeaver solution. This SAP RIG has expertise in BI, EP, XI, and WebAS. They contribute their implementation expertise to the SDN implementation forums as well as to the SAP NetWeaver Know-How Webinar Series.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    May 06, 2004 at 01:31 AM

    Consider using a supported RDBMS as your main staging DB for non-SAP sources. Write views in this staging database against other DB's via ODBC. This solves the problem of accessing sources that are not supported by BW; you only need to define one connection in BW; it provides greater flexibility in data staging; it provides an access point to the same data using other tools.

    Add comment
    10|10000 characters needed characters exceeded