DB Connect to Progress DBMS

[Former Member]

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

[Former Member]

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.

[moyalynne]

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.

[moyalynne]

... and if you missed that, here for the transcript:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/sap bw universal data integration.article

cheers,

-m