[4735] in sapr3-soft
Connectivity between SAP (CO-PA module) and MS SQL Server
daemon@ATHENA.MIT.EDU (Olivier Delande)
Wed Jan 5 11:01:41 2005
To: sapr3-soft@mit.edu
Date: 5 Jan 2005 08:01:37 -0800
From: odelande@openexecutive.com (Olivier Delande)
Message-ID: <bc9e525b.0501050801.4ba4af36@posting.google.com>
Hello,
I need to extract data from the CO-PA module of SAP (Oracle DB) to SQL Server.
I would like to know what technics would apply best ?
* DTS using ODBC, but underlying SAP data structures seem undocumented,
* SAP.NET ?
* are there ways to export CO-PA data to a flat file and then bcp ?
Thank you for your help and advices.
I'm looking for setting a link between SAP and Analysis Services.