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
2 Answers
-
Posted on 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.
Heres 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
-
Former MemberPosted on May 06, 2004 at 01:31 AMConsider 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
Add comment