Extract Table from SAP with BizTalk

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Extract Table from SAP with BizTalk

Viewing 1 reply thread
  • Author
    Posts
    • May 5, 2010 at 3:08 PM #24650
      community-content

        Hello,

        we are having a running BizTalk 2006 R2 and are looking for a way to extract easily data from SAP into SQL.

        It is possible to extract a whole table or only a subset  with the BT every day on a specific time?

        If so, can somebody give me a short instruction how to setup such a data extract?

        Thanks a lot in advance!!!

      • May 5, 2010 at 3:40 PM #24651
        community-content

          Hello again,

          I just found some information, which partially answers my question [:)] .

          The adapter pack comes with an ADO layer to connect to an SAP system, which can be used to extract data with SSIS.

          That are the good news for now. Still I’m not sure if it’s possible to do it directly with BizTalk.

          Regarding the SSIS, there is a new question: It is possible to install the adapter pack on an Windows Server 2k3 or 2k8 without having the BizTalk installed on this machine?

          Cheers!

          • May 6, 2010 at 1:22 AM #24652
            community-content

              Adapter pack  comes independent of BizTalk, so you can install and use it withlit BizTalk.

              Regrding the other question- you can extract data from SAP into SSIS using  the SAP adapter ADO provider.  This will write the data into a SQl tabel.
              Then, you can use the SQL adapter  polling to get the data into BizTalk.

              • May 6, 2010 at 1:24 AM #24653
                community-content

                  The only prerequisite for adapter pack is Adapters SDK, which is free to download.

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