January 06, 2009, 02:52 PM
ESkyHow to publish a Data Migrator procedure
Hi All,
I created a procedure via DMC, but when I open IWay Adapter Designer and want to configure an RDBMS adapter to generate the schema. The newly created procesure is not in the list. I have tried refresh the list. It doesn't work.
Does anybody know if I need to publish the data migrator procedure in order to see it in iway adapter designer?
Or anything I can check?
Thanks,
Dennis
January 29, 2009, 05:20 PM
KerryHi Dennis,
Here is suggestion from DM folks: it will depend. In order for the procedure to be visible to iAM or iSM (using the RDBMS adapter -> iWay/WF Reporting Server) you need to catalog it.
You need to run a fex DIR:\ibi\apps\ibisamp\rpccat.fex. If you cannot locate this fex, please contact The Server support team at Information Builders. From the Web Console, go to procedures expand the application path and right click on rpccat.fex and select run. You can then select the application path for the RPC and RPC name.
Hope this helps.
Cheers,
Kerry