How to enable DB2 connection from HP OO Central 10.20
I got the answer to this question (see below) when using Studio, but now that I am trying to test in HP OO Central 10.20, I'm hoping someone can help provide a counterpart solution when using Central.
To enable DB2 LUW connections from HP OO Studio, you need to copy 2 drivers from the IBM DB2 software directory to the HP OO software directory as shown below..
- Create the 2 highlighted directories within the HP OO Studio directory structure.
C:\Program Files\Hewlett-Packard\HP Operations Orchestration 10\studio\lib\ext\com.hp.oo_oo-sql-legacy-plugin
- Copy the following 2 DB2 drivers (jar files) from the below IBM directory into the above newly created HP directory.
Then you can utilize the HP OO provided operations like ‘SQL Query’ for DB2 LUW databases (that you have access to).
Unfortunately, OO central does not support DB2.
You are able to develop content (flows) that connect to a DB2 database (or any other type of database)
as long as you provide a suitable database connector and as long as your code compiles...
OO central on the other hand has a set of supported database types: Oracle, SQL Server, MySQL and PostgreSQL.
If you attempt to connect central to DB2, you will end up with a failure as OO central will not recognize the database type and will not know how to properly set up the schema, or how to properly format the SQL queries.
To have the content working from Central you actually need to package the 3rd party libraries you are mentioning in a Content Pack and deploy that Content Pack into Central.
The documentation available here provides some examples on how to do it for MySQL or other integrations. My suggestion is to follow those examples for DB2 as well.
Hope it helps,