From SAP to excel

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

Viewing 1 reply thread
  • Author
    Posts
    • November 9, 2005 at 10:24 AM #12232
      community-content

        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.

      • January 19, 2006 at 5:13 PM #12233
        community-content

          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.

          • November 9, 2005 at 5:24 PM #12234
            community-content

              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.

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