Announcement

Collapse
No announcement yet.

OTM and SQL SERVER

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • OTM and SQL SERVER

    Hello everybody!
    How can i transmit data from OTM to SQL Server when I add new records into OTM.?

  • #2
    Hi,

    No need to transmit by default it will store the data in Database and you can access the data from SQL

    Regards,
    Narayana

    Comment


    • #3
      Originally posted by naresh1 View Post
      Hi,

      No need to transmit by default it will store the data in Database and you can access the data from SQL

      Regards,
      Narayana
      Thanks for your reply
      But that way i will need to query the table to get the data from OTM through XML. What I need is new data will automatically adding from OTM into SQL server in real time .
      Sorry for my English was terrible.

      Comment


      • #4
        Hi,

        I am sorry i couldn't able to understand exactly what you're looking

        As far as I understand you want to take the XML from the OTM for the object lets say for Order Release

        Navigation: Business Process Automation > Integration Manager > Perform an Integration Command
        Select XML Element ID(For Order Release you have to select Release)
        Enter Object ID(That is order id ex:12345)
        Then Click on process to generate the xml for the order similar way for all the remaining objects

        Regards,
        Narayana

        Comment

        Working...
        X