Microsoft SQL Server provides a completely new enterprise extraction, transformation, and loading (ETL) platform called SQL Server Integration Services (SSIS) that ships with the features, tools, and functionality to build both classic and innovative kinds of ETL-based applications.
This article presents details on how to use the XML Web Interface to deliver content from Siebel to external portal frameworks and Web application environments. The XML interface provides industry-standard integration to third-party development environments, such as ASP and JSP, as well as providing a model consistent with emerging Web technologies. The XML interface can be used across all Siebel eBusiness Applications.
Sometimes data coming in inbound integration from external system cannot be uniquely identified.
One of the options is to use "SIS OM PC Service" business service in datamaps and the generated output row_id could be used as user key during the insertion. In the field map following expression is used:
InvokeServiceMethod("SIS OM PC Service", "Get Next RowId", "XYZ='12'", "RowId")
eXtensible Markup Language (XML) is a markup language used to structure data to make it easy to exchange data over the Internet. The compatibility of XML with various other languages, such as Java and C++, has given rise to various tools and utilities such as XML editors, parsers, and browsers that help structure data in an XML document.
The following steps can be used to debug and increase EAI Siebel Adapter performance related issues:
1. To improve the performance of integration objects:
The objective of this document is to describe the functioning of real time process. In the real time process the record from the external system is directly entered into UCM SDH (Source Data History) tables. The record is read from XML file and passed to the UCM source table and forwarded to the Siebel base table directly depending upon the survivorship rules. An output file which is a XML file is created for further reference.
Functional Description:
The XML Web Interface can be used against any Siebel eBusiness Application. Requests to generate XML from Siebel eBusiness Applications can be submitted through a Siebel Web Server using a query string or an XML command block.
Example:
Code Snippet to open HTTP connection to SWE get data from account list applet – using XML command:
###################################################################
<% @LANGUAGE="VBScript" %>
<%
Q1. MW has pushed a message but it is not showing up on the Siebel UI or in the database. What should I do?
You can check for any one of the below or all of the below
a. Check if the Adapters are up and running.
b. Check if the Adapters are using the right srf
c. Look for the errors generated in the folder \Sybase39\Siebel-3_9\bin. The log file names are usually
similar to the Adapter dat file names