Focal Point
[RESOLVED]iSM data migrator ETL object

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/1867077426

October 03, 2012, 01:06 PM
Shirley
[RESOLVED]iSM data migrator ETL object
Hi,

I'm new to iSM. I want to run a data migrator job from iSM. When I'm trying to configure the ETL object in iSM, i'm getting this error(please see print screen image).

Does anyone know that if I need to setup something before I can start using the ETL object in iSM?

http://www.flickr.com/photos/3...hotostream/lightbox/


This message has been edited. Last edited by: Shirley,


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
October 04, 2012, 10:20 AM
Clif
This error occurs because Service Manager is attempting to invoke a stored procedure called EDAEXEC to issue commands on the DataMigrator server instead of executing them directly.

For security reasons this procedure is disabled. To enable it, please go to (by default) c:\ibi\srv77\home\catalog directory and rename edaexec.dat as edaexec.fex.


N/A
October 05, 2012, 05:13 PM
Shirley
Hi Clif,

Thanks. It's working now.

Cheers,


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16