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


        • #5
          Hi, I don't think it's possible to replicate data in real time from OTM oracle database to Sql Server. You could use SQL Server Integration Services (SSIS) to schedule a Job to PULL OTM data on a daily basis. Normally this is done during off hours when no one is using OTM . Of course, if you have Off time windows in your business.


          Regards,
          Ravi

          Comment


          • #6
            You can directly access the data from the SQL server tables using the SQL Servlet. Just add this path after your OTM URL:-
            GC3/glog.webserver.sql.SqlServlet

            Here you can directly query the associated tables to get the result. Why do you need to add the data to another table? The data is already present in tables. Just query the table using this.

            Comment

            Working...
            X