Skip to Content

Transferring data from MaxDB to MSSQL

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 24, 2009 at 01:30 PM

    > 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

    Add comment
    10|10000 characters needed characters exceeded

    • > 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

  • avatar image
    Former Member
    Jun 24, 2009 at 04:45 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 25, 2009 at 10:41 AM

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

    Nelis

    Add comment
    10|10000 characters needed characters exceeded