Service to extract JDBC connection info

Hi all,

Could you please let me know how to extract list of JDBC connection from IS. Is there any service to do that? How does DSP page extract when we click view JDBC connection in IS?

I know pub.art.service:listAdapterServices. but i want to know the host name and DB service name and other connection properties. I can see it from IS. But as part pf DB migration i need to details from around 42 servers

Hi Surya,

which type of DB Migration are referring to?
Is it just version update and/or moving to a new host or are you changing database vendor?

You can investigate the node.ndf of the Connection and decode the Base64-coded Value.
In this decoded structure you will find all the parameters of the connection.

Regards,
Holger

Hi Holger, Thank you for the advice and explanation.

Migrating from oracle 10g to 11c. Could you please let me know the path for node.ndf file? I need connection properties like ‘host name’,‘portnumber’,‘other properties’,‘user’ and details like that from webMethods adapter for JDBC tab. I am using 9.8 version currently. As part of this migration I need to take backup of existing JDBC connections and adapter details and verify later once the migration is complete. Could you please let me know how to take the backup?

Thanks
Surya

Hi Surya,

the node.ndf is located under /IntegrationServer/instances/default/packages//ns//.

The package names, the folder names and the Connection Name can be obtained from JDBC Adapter page or from Designer -> ServiceDevelopment View.

Regards,
Holger

Thank you for the information. I know where to check for the details but in case of more number of adapters its difficult to check one by one and copy the JDBC Connection details and keep a back up since we have many Connections and lots of servers. Can you advise any simple idea?

Hi Surya,

you can take an archive of the packages where the connections reside.
Remember to disable them first.

If you want to check the parameters by a service you can list the connections by using ART Built-In-Services and XQL (XML Query Language).

Outline:
list all connections for type JDBC
LOOP over connection list
get node.ndf from filesystem.
get base64 coded property from it by XQL
decode base64
Store the xml somewhere
LOOP end

You will find Built-In-Services for this in the IS Built-In-Services reference.

Regards,
Holger

Hi Surya,

We list JDBC adapter connection info by:

Invoke pub.art:listRegisteredAdapters
Loop over results.
Invoke pub.art.connection:listAdapterConnections (adapterTypeName is from listRegisteredAdapters).
Loop over results.
Invoke wm.art.admin.connection:getResourceConfiguration (connectionAlias is from listAdapterConnections).
Get values from ‘parameters’ output.

-Mary

Hi Surya,
Forgot to mention that we write this to .csv file and store in a spreadsheet.
-Mary

Hi Mary,

Thank you. Could you please tell me the location or path of the spreadsheet where to find it?

Thanks
Surya

Hi Surya,
Once you have your adapters list in a string (with new line and comma delimiters) you can invoke pub.file:stringToFile which will create a file in the IntegrationServer directory. Then you can move it to wherever you like. In our case, we attach and send via email.
-Mary