Since PCM 7.5 SP3, Data Bridge can connect to SAP BW and any other ODBO source system (including itself!). A test tool called lsdal explorer is also provided to explore structure and measure data from various source systems.
Define a Link ID to a BW System
In addition to the steps below, defining a Link ID can also be done from within the DataBridge Wizard.
Start Data Bridge (menu path All Programs>SAP Business Objects>Profitability and Cost Management>Data Bridge
Click Cancel on the – “Create new DataBridge Control File“ popup
Select Run>LSDAL Explorer
Click the Create Link ID icon
Select DataSourceType SAP NW BI RFC (specific server) (Note that this is where you could also select other ODBO sources or Oracle or DB2 providers)
Maintain the following parameters - Link ID (ETD – note can be any name) - System (ETD – note must be BW system ID, in this case ETD) - App Server (localhost – this will vary by BW installation and usually be an IP address or hostname) - SAP System Number (00 – this will vary by BW installation) - User ID (PCMELITE) - Password (welcome) - Language (EN) - Client (001 – note this will vary by BW installation)
Click Test and confirm successful connection
Expand the new Link ID in the left hand pane to browse the BW Queries and Infocubes