[4735] in sapr3-soft

home help back first fref pref prev next nref lref last post

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.

home help back first fref pref prev next nref lref last post