Jsneed,
Theoretically the answer is yes..
You just need to get the JDBC driver for the Cache DB and install it on the DLP Discover server. The DLP discover server is capable of connecting to ANY DB as long as you have the right JDBC drivers for it.
To configure a scan of Cache DB, do the following:
-
- Obtain the JDBC driver for the cache DB
- Place the file in the jdbc directory of the Discover server (/lib/jdbc)
- Modify the permissions on driver so that the Protect user has full r/w/x
- Edit the following entry in the sqldatabasecrawler.properties file, look at the other entries and you will see how to set it up:
driver_class.cachedb = "enter the com name"
driver_subprotocol.cachedb = "another setting"
driver_jar.cachedb = "jar name of driver"
driver_table_query.cachedb = SELECT table_schema || '.' || table_name from qsys2.systables where table_schema = '<schema name>' (this is probably wrong, but I hope you get the idea.)
driver_row_selector.cachedb = SELECT * FROM {0} FETCH FIRST {2} ROWS ONLY (this is probably wrong, but I hope you get the idea.)
quote_table_names.cachedb= true
5. Add the credentials to the scan target and use the following syntax for the connection string: cachedb://hostname
Also look at the online help.. it will out line how to configure new DB.
Hope this makes sense.
If this solves your questions please marked as solved.
Ronak