Transferring data from MaxDB to MSSQL

[nelis]

Hi,

We currently export data from our ERP 6 system running MaxDB 64bit 7.6.06 on Linux to a tab delimited text file which is then imported into a SQL 2005 database(via some KIDZ program). I was just wondering if we could simplify this process and write something in SAP to connect directly to MSSQL and transfer the data.

I've been searching in the maxdb documentation and wiki but haven't come across anything that stands out that may help us, perhaps I'm just not looking for the right thing.

Any pointers ?

Thanks.

Regards,

Nelis

[markus_doehr2 · Accepted solution]

> We currently export data from our ERP 6 system running MaxDB 64bit 7.6.06 on Linux to a tab delimited text file which is then imported into a SQL 2005 database(via some KIDZ program). I was just wondering if we could simplify this process and write something in SAP to connect directly to MSSQL and transfer the data.

If you add a Windows application server to your landscape (possible, supported) you can use DBCON to do a secondary connection directly from the system to the external database.

Since there is no database client for SQL Server on Linux this doesn't work "natively".

Markus

[nelis · Accepted solution]

Thanks for your reply.

What about the other way round, MSSQL(linked server) -> MaxDB ?

...or would this route not be recommended or supported by SAP ?

Nelis

[markus_doehr2 · Accepted solution]

> What about the other way round, MSSQL -> MaxDB ?

>

> ...or would this route not be recommended or supported by SAP ?

sure - as long as a database client for the target database is available.

Markus

[nelis]

May just give this a go: http://www.freetds.org/

Nelis

[Former Member]

You could also try to use an ETL tool: it could operate the transfer you are talking about.

Talend Open Studio is an open source ETL tool for data integration experts with a user-friendly GUI, easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component which allows the user to get a graphical and functional view of integration processes. For more information: http://www.talend.com/

[nelis]

Thanks Tgouru, I will take a look a look at it.

Nelis

[Former Member]

Hi,

Please check the notes Ms-sql 512739, SAP DB 520647,oracle 518241.

Thanks,

Pundari

Edited by: pundari kakshayya on Jun 24, 2009 10:17 PM