Connecting MS SQL to SAP BW using SAP BW OLE DB Provider

Connecting MS SQL to SAP BW using SAP BW OLE DB Provider

Post by Apolloman » Thu, 12 Aug 2004 02:18:10


I am trying to connect to a SAP BW database from MS SQL2K through a
DTS Package using the standard SAP BW OLE DB Provider connection.

The connection test is OK but after selecting the catalogue and moving
through to selecting the Tables to import I can see only tables that
are both not recognised and as far as I can see do-not exist but none
of the objects that have been created.

We have tried different user ID, authorisation etc but with no luck.

Has anyone seen this type of problem before ?

Thx

N

--
http://www.yqcomputer.com/ 's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.yqcomputer.com/
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.yqcomputer.com/
 
 
 

1. Unexpected row shift using SAP BW OleDb provider with SAP BW 3.5

2. US-NJ-Newark: SAP SEM/BW Programmer, SAP Basis SEM/BW; 5M (45299060412)

US-NJ-Newark: SAP SEM/BW Programmer, SAP Basis SEM/BW; 5M (45299060412)
========================================================================

Position: SAP SEM/BW Programmer
Reference: SMC01398
Location: Newark NJ
Duration: 5M

Skills: Required Skills: SAP Basis SEM/BW


Scope: Activities 1) Support During Data Load's 2) Transport 3) Other
Basis Issues
-Support Packs
-Application of OSS Notes
-Resolve IGS Configuration Issues
-Resolve System Performance Issues 4) Other
-Complete additional Basis support for CPI project (complete
installation of SEM/BW production (EP0)
-Define, write and test the operational
-Knowledgeable in SEM/BW and ITS/IGS
-onsite and oncall


Please send your current resume in confidence to < XXXX@XXXXX.COM >

.45299060412.

3. US-NJ-Newark: SAP SEM/BW Programmer, SAP Basis SEM/BW; 5M (45299060413)

4. US-AL-Huntsville: SAP Functional Support, SAP R/3 FI/CO, SAP BW; C-P (45301357604)

5. US-AL-Huntsville: SAP SEM Configuration Analyst: SAP BW Apps., SAP R/3 (FICO); C (45283732408)

6. US-AL-Huntsville: SAP Functional Support, SAP R/3 FI/CO, SAP BW; C-P (45299257607)

7. US-AL-Huntsville: SAP Functional Support, SAP R/3 FI/CO, SAP BW; C-P (45301032409)

8. US-AL-Huntsville: SAP Functional Support, SAP R/3 FI/CO, SAP BW; C-P (45301332410)

9. US-AL-Huntsville: SAP Functional Support, SAP R/3 FI/CO, SAP BW; C-P (45300432401)

10. US-AL-Huntsville: SAP SEM Configuration Analyst: SAP BW Apps., SAP R/3 (FICO); C (45283457609)

11. US-AL-Huntsville: SAP Functional Support, SAP R/3 FI/CO, SAP BW; C-P (45299832403)

12. US-AL-Huntsville: SAP SEM Configuration Analyst: SAP BW Apps., SAP R/3 (FICO); C (45283157617)