Accessing Data Federator Catalog as Data Server?
Using MII 12.1 SP6 and Data Federator XI 3.0.
Is it possible for MII to treat a published Data Federator Catalog as a Data Server? I would like to query the target tables in the DF catalog with MII. If yes, how would you go about doing so? Are there any examples available? I know that DF has the JDBC thindriver.jar file that can be used by some applications, so if that is uploaded into the JDBC drivers in MII 12.1 and set the serverURL to the DF catalog path would that work? Any known gotchas?
In the past I've had issues uploading and deploying multiple JDBC drivers at once but presumably the thindriver and oracle drivers won't negatively interact?
For JDBC Driver I used: LeSelect.ThinDriver.ThinDriver (I feel like this is potentially the problem but nothing is listed here in DF manual. I also tried a few other combinations but nothing seemed correct)
For ServerURL I used jdbc:datafederator://<server>:<port>/KerbyTest and jdbc:leselect://<server>:<port>;catalog=KerbyTest and jdbc:datafederator://<server>:<port>/catalog;KerbyTest
With the jdbc:datafederator://usto-dapp-ois01:3055/catalog;KerbyTest ServerURL I don't get a failure message, the status just stays at pending.
I haven't seen anything on this from either MII or Data Federator so wanted to ask before I experimented too much with it.
Thanks for the help,
Edited by: Kerby Johnson on Mar 24, 2011 12:35 AM