Fetching value of Oracle Sequence from External DB

Fetching value of external Oracle Sequence in Siebel is one of the typical business requirement in integration of Siebel applications. In case of windows environment solution is quite straight forward, we just need to create ADODB object in script and execute sql on external database.

But in case of Unix environment this is not possible as ADODB is not supported in Unix.


For this requirement we can use External Business Component or "EBC" to fetch the next value of an external sequence.

Solution:
1. Create external table in Siebel database using the External Table Schema Import Wizard.
2. Create additional column in table and set Alias property of the column with concatenation of external column name and the external oracle sequence like:








Siebel will use this Alias property of the columns to build SQL for external tables. So when building SQL in this case it will concatenate the column value with the nextvalue of the specified sequence.

After this, compile all the changes and query on BC based on this table and process the field value to fetch next value of the sequence of external database.
Category:

Comments (7)

Loading... Logging you in...
Dashboard | Edit profile | Logout
  • Logged in as
+2 Vote up Vote down
Ivar's avatar

Ivar · 733 weeks ago

Very nice solution. I had to create one record in the external table to have this solution work in WF.
1 reply · active less than 1 minute ago
Loading...
+2 Vote up Vote down
Tejeshwer's avatar - Go to profile

Tejeshwer 34p · 733 weeks ago

I am glad it helped someone... :)
+2 Vote up Vote down
Oracle Siebel CRM's avatar - Go to profile

Oracle Siebel CRM · 609 weeks ago

Thanks, nce solution
+2 Vote up Vote down
SeibelUser's avatar

SeibelUser · 593 weeks ago

Do we have any DB connector or adapter which can be use to dynamically access/fetch data from external DB.
We need to connect dynamically to external DB instance on the basis of given input.
e.g.:- Employee data is residing externally to multiple DB instances, and DB instances are separated on the basis of country.Now From CRM we have to fetch the data for an employee whose data resides on any one DB instance as per his country.
1 reply · active 593 weeks ago
+1 Vote up Vote down
Tejeshwer's avatar

Tejeshwer · 593 weeks ago

Why don't you create multiple EBC? Even if they are in hundreds they won't get executed until condition is satisfied.
+1 Vote up Vote down
sekhar's avatar

sekhar · 499 weeks ago

hi guys This is Chandrasekhar, i have been into Siebel CRM since 7 years , i have been worked various modules,
I will give you Good technical Training on Siebel CRM, Siebel EAI, Scripting, workflows, configuration, EI).
look @ my Demo @ https://www.youtube.com/watch?v=w2bt_WtRg1Q.
if you need technical support or Training , or any help on interviews , please feel free to contact me @ +919035705781 or mail me @ sekhar.yaragudi1@gmail.com@gmail.com
+1 Vote up Vote down
chandra's avatar

chandra · 499 weeks ago

hi guys This is Chandrasekhar, i have been into Siebel CRM since 7 years , i have been worked various modules,
I will give you Good technical Training on Siebel CRM, Siebel EAI, Scripting, workflows, configuration, EI).
look @ my Demo @ https://www.youtube.com/watch?v=w2bt_WtRg1Q.
if you need technical support or Training , or any help on interviews , please feel free to contact me @ +919035705781 or mail me @ sekhar.yaragudi1@gmail.com

Post a new comment

Comments by

Subscribe to: Post Comments ( Atom )

Other Siebel Blogs

siebel-admin-l @ IT - toolbox

siebel-dev-l @ IT - toolbox