This article has been contributed by Prashant Jha. In this article he explains scriptless solution for a seemingly complex requirement and demonstrates a great example of Siebel EAI in action.
Here is a requirement wherein we need to export data from Siebel DB to an external system in a CSV file Format. As soon as we hear this the first thing that comes into our mind is SQL developer. We can easily run a select query and extract the records and then export in any format we want. But what if the client wants only Siebel ways to do this? For exporting data into CSV file Siebel does not provide any Out-of-Box Business Service which can complete my task. To accomplish this requirement we have two ways:
- Using EBC to populate data into an external table from which we can schedule a job which exports data into CSV (Almost the SQL developer way. Just that we are not extracting directly from Siebel tables.)
- Using a Workflow that employs Out Of Box (OOB) business service to accomplish this.