When we create any configured operation in SQL Server Intelligent adapter, we have to specify 1st the user name and when we select the user name the list of tables owned by the user are displayed. Generally all tables in SQL Server are owned by dbo.
But if in our case the table is not owned by DBO and we have different users in development database and production database. After importing the development integration in the production, I have to manually go and chg the user name field in all the integration component. Otherwise the integration does not work.
In this case we are specifically changing the code after moving it in production. How to avoid such problem?
Hi Vandana,
can u tell me what driver is required to configure the sql server(intelligent) adapter.what parameter need to pass on “Add to CLASSPATH” Tab. i am unable to configure the SQL server adapter.u need to install SQL client first before configuring the adapter???.
Ur responce will be highly appreciated,
Regards,
Ashu
Hi jayaraman,
ok fine i just gave the username,servername and password but it is giving error. do i need to install sql client before configuring the adapter.
Regards,
Ashu
Your problem is what occurs in everyday situation at our workplace. SQL Server, AS400 or DB2. All these databases get their configured operations reset when you import the Integration components.
The best way (not the wM recommended way atleast) is to export the component as an adl. Open the adl either in NotePad or TextPad, look for the Userid, replace it with the Production’s Userid and save the adl. No changes anywhere other than where you require to do so.
Now import the adl, and LO!!!, you should have the exact userid and table name as needed for your Production environment in your Integration.