Skip to Content
avatar image
Former Member

Syclo to MSSql to SAP database

Hello All , I have requirment in syclo is SAP Syclo communicate to MssSQL and store all data in MSSQL. After that MSSQL DATA Should be transfer to SAP database (SAP Tables ). 1) is it possible ? 2) May i know , if its yes then how can we do best way ? Thanks & Regards,   Kunal Varaiya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2014 at 04:09 PM

    Kunal,

    Yes, it is possible to have Agentry communicate only with a SQL backend.  I am assuming you are custom building your application.  If you are asking about taking one of the existing products and inserting SQL as an intermediate storage then while it is technically possible it would take a lot of work.

    The question will be why not directly put the data in SAP?  What are you trying to accomplish by using the intermediate database?

    In terms of then having the data flow to SAP, the best method for that will depend on a number of factors related to your application requirements.  Things to consider include:

    • How soon the data needs to move from SQL to SAP
    • What should happen to the data once transferred.
    • How are errors to be handled
    • etc.

    All of these need to be taken into account when deciding on the architecture and transfer methods.

    --Bill

    Add comment
    10|10000 characters needed characters exceeded