none
Biztalk RRS feed

  • Question

  • I am using BizTalk for the first time. I am using Microsoft SQL Server. I want to send claims for physicians to a clearing house. How do I take the data from my SQL Server and create a 837 formatted file and send it to a clearing house? Do I have to use special clearing houses that can connect to a Biztalk server?
    Friday, May 14, 2010 12:50 PM

Answers

  • Mike,

    You can connect to SQL through BizTalk.  BizTalk will poll SQL every so often (configurable in the Receive Port).  Once the data is pulled into BizTalk you will map it into an 837 format and send it to the clearing house.  The clearing house does not need to connect to BizTalk, rather you can push the data to the clearing house using a protocol that they have available (FTP, WCF, etc).

    I would recommend that you take a look at the hands on labs:  http://www.microsoft.com/biztalk/en/us/virtual-labs.aspx.  They may give you a good overall view of how BizTalk works. 

    -Elizabeth

    Friday, May 14, 2010 7:42 PM
  • Hi Mike,

    Here are the artefacts which you need to create.

    1- Stored procedure to get the data from SQL. Return the result set in XML and XML schema should be similar to 837 schema.

    2- Create a map to map sql output to 837 schema.

    3- Send the 837 to the clearing house.

    We have implemented similar solution for EDI 210, 940 etc.

    Let me know if you require any further help.

    Regards, Vishnu


    Vishnu
    Wednesday, May 19, 2010 11:54 AM
  • If you also want to use a custom 837 format, the following article will be quite good reference:

    http://chaosedge.net/blog/category/Biztalk-Server.aspx

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, May 24, 2010 9:38 AM
    Moderator

All replies

  • Mike,

    You can connect to SQL through BizTalk.  BizTalk will poll SQL every so often (configurable in the Receive Port).  Once the data is pulled into BizTalk you will map it into an 837 format and send it to the clearing house.  The clearing house does not need to connect to BizTalk, rather you can push the data to the clearing house using a protocol that they have available (FTP, WCF, etc).

    I would recommend that you take a look at the hands on labs:  http://www.microsoft.com/biztalk/en/us/virtual-labs.aspx.  They may give you a good overall view of how BizTalk works. 

    -Elizabeth

    Friday, May 14, 2010 7:42 PM
  • How many tables are you using for the claims?
    Please Indicate "Mark as Answer" if this Post has Answered the Question
    Monday, May 17, 2010 2:59 PM
  • Hi Mike,

    Here are the artefacts which you need to create.

    1- Stored procedure to get the data from SQL. Return the result set in XML and XML schema should be similar to 837 schema.

    2- Create a map to map sql output to 837 schema.

    3- Send the 837 to the clearing house.

    We have implemented similar solution for EDI 210, 940 etc.

    Let me know if you require any further help.

    Regards, Vishnu


    Vishnu
    Wednesday, May 19, 2010 11:54 AM
  • If you also want to use a custom 837 format, the following article will be quite good reference:

    http://chaosedge.net/blog/category/Biztalk-Server.aspx

     


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, May 24, 2010 9:38 AM
    Moderator