Database Accounts for Message-Based Submissions

It is possible to trigger the execution of a job in Oracle Life Sciences Data Hub by sending an XML message from an external system on a remote database.

To set this up, do the following:

• Create an Oracle LSH user account and database account
• Create a database link on the remote database to the Oracle LSH database using the Oracle LSH database account ID and password
• In the XML messages, embed the Oracle LSH user account ID in the appropriate place in the XML message. See "XML Message Requirements" in the Oracle Life Sciences Data Hub Application Developer's Guide for information on the required XML schema for these messages.

  An Oracle LSH API called CDR_EXE_MSG_API with the procedure Submit Message is available for use in enqueuing messages. See "Using Message-Triggered Submission from External Systems" in the Oracle Life Sciences Data Hub Application Developer's Guide for further information.

  For general information about enqueuing messages, see the Oracle® Streams Advanced Queuing User's Guide and Reference at http://download.oracle.com/docs/cd/B19306_01/server.102/b14257.pdf.