EBC Configuration problem
We have a requirement to create a new View(Applet) from EBC where the table was created on SQL View.
Before this requirement, there was already one EBC and applet which is even deployed in PROD and running from very long time.
Below is the process we followed to meet requirement......
We also have DB connection details, like table owner, username and password, we also created an entry in Oracle client (administration installation) and data source also been created and tested successfully. So we have entry in Oracle client, Data source is created and Infradatasource is created in Siebel client (while created this, clicked new Infradatasource, didn't copy existing). DSN name and Infradatasource profile name was given same and the entry in uagent.cfg(call center application) is also created and given same name.