Multiple RDBMS connections?

[samreddy69]

Hi All,

I have a question regarding multiple RDBMS connections to SC 6.1 . My customer would like to push all data to Oracle and at the same time pull some DB2 data into incident screens. Is this possible? and if so... do we need connect.it for DB2?

Asked support and they directed me to DB Admin guide... couldnt find this scenario. Appreciate any insight.

Sam

[tommy]

Let me see if I understand. Do you want to pull data from a DB2 when viewing an incident? For example get detailed information about a contact or device or something else?

You could probably use soap to pull data if there is a webservice available on the db2.

[samreddy69]

Let me see if I understand. Do you want to pull data from a DB2 when viewing an incident? For example get detailed information about a contact or device or something else?

You could probably use soap to pull data if there is a webservice available on the db2.

Hi Tommy,

Yes... this customer has huge contact files (millions of records) that they want to display in their call open / incident open screens... (they dont want this info in SC due to size and duplication issues) mainly in DB2 database. They would like to pull this data and save it as part of the incident. I know they have all kinds of webservers here.

Is there any information/documentation on how to do this via SOAP (API). I asked Support about SOAP API and they didnt know the answer.

[samreddy69]

Ok, support just emailed me that Connect-It isnt required... how do you connect two different databases?

[meichler]

what we did is something similar. we have also pushed our data to oracle. Some inventory data are stored on "another database". To access this "other database", we use the transparent gateway feature (hope I got the right naming) in Oracle.
So, the inventory database is only a view in oracle, refering to the "other" database. The ServiceCenter inventory dbdict is mapped to this view.

- create (or use existing) dbdict in SC
- Move dbdict to oracle
- drop table in oracle and create a view with same name and same fields (this view points to the other db)
- when retrieving inventory, SC now gets the data from the "other db"

[MKBell2000]

Hi Sam, this can be done as you request. In the Database Admin manual/PDF guide, there is a section on adding multiple databases. The same way in the sc.ini file you add your Oracle database, you can add multiple databases of different types. There are also instructions on how to map dbdicts to existing tables. You create a dbdict that matches your DB2 table, then manually edit the dbdict to root record -1 and set up all the sql tables and fields. I did this, but all in one Oracle database. One SC table actually pointed to an Oracle view of 2 tables, there was one Company table of about 50,000 entries, and a Contacts table with about 1million entries. You will need to do some careful debugdbquery traces, optimize your links/search screens, and carefully tune and index your DB2 tables to get acceptable performance on these searches. Something that is very quick in direct SQL, slows down considerably when run thru SC.

Hope that helps, feel free to ask more questions!
Malcolm