From SAP to excel

Home Page Forums BizTalk 2004 – BizTalk 2010 From SAP to excel

Viewing 1 reply thread
  • Author
    • #12232

      I am a beginner in BizTalk and want to ask the possibilities of maybe use BizTalk as a sort of SAP datalayer to a sql server db and from there get information via msquery in excel.

    • #12233

      You can save an Excel worksheet as XML and then see how the schema is constructed.

      I have transformed Raw XML to Excel XML with an XSLT that I wrote, but not using Biztalk, however it should be possible.

      • #12234

        Well, it really all depends on what exactly you want to do.

        Biztalk can integration with SAP through the SAP Adapter. That will be included with Biztalk 2006. Also, integration with SQL is built in through the SQL Adapter.

        So, it would really be a matter of getting the data out of SAP via the adapter, mapping it, and putting it into SQL.

        I do not know of an Excel Adapter. You might have to export the data as a csv or something Excel can import.

        Hope this helps.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.