June 06, 2008, 08:33 AM
<Ranga>invoke data migrator from java
can any one tell how to invoke a
data migrator process from
JavaJune 12, 2008, 11:10 AM
KerryHi Ranga,
Did you open a case with Customer Support Services regarding this issue? Have you got a chance to review the suggested online document:
Starting Flows With CMASAPHope it helps.
Cheers,
Kerry
June 12, 2013, 10:55 AM
benicelyI hate to reopen such an old post, but I have the same exact question.
Should I open a ticket instead?
June 14, 2013, 09:27 AM
AJHi Benicely,
For this issue it would be best to open a case with technical support.
Thanks,
Alan
June 14, 2013, 09:29 AM
AJHi Benicely,
I meant to say Information Builders Customer Support Services.
Thanks again,
Alan Boord
Focal Point Moderator
June 14, 2013, 09:31 AM
benicelyThank you AJ. I will open a case.
June 14, 2013, 12:44 PM
benicelyThe link by Kerry is for an older version. If anyone else has this problem, the solution, for now, is to use Java to call the CMRUN.exe file. I'd post a link to the documentation, but I'm not sure if that's allowed.
June 25, 2013, 11:39 AM
<Kathryn Henning>Hi benicely,
For documentation, you can refer to the topic name in the "___ chapter in the ___ manual", for example. Or, if you prefer, you can provide the DN (document number).
Cheers!
Kathryn
July 04, 2013, 09:17 AM
dhagenYou can connect to any iDM server using JDBC. The JAR is jlink.jar, the driver: ibi.jdbc.EdaDriver, url example: jdbc:eda://localhost:8116;server=LOOPBACK
You will have to call a custom stored proc that will then will invoke the CMASAP for you. If you wish to have the stats returned as an answerset, then the following will work:
-* Proc name: runflow.fex
-* Parameter names:
-* 1 - data flow name
-* 2 - application directory
-* 3 - parameters to be passed to the flow
-* Must be passed as key value pairs seperated by commas
-* e.g. COUNTRY=ENGLAND,CAR=JAGUAR
-DEFAULTH &1 = 'NONE'
-DEFAULTH &2 = 'baseapp'
-DEFAULTH &3 = ' '
-* following just to prevent prompting
-DEFAULTH &&DEP_1_RC = '99'
-DEFAULTH &&DEP_1_ID = 'UNK'
-* ensure a flow is requested
-IF &1 EQ 'NONE' GOTO :SKIP_ALL;
-* set params
-SET &PARAMS = IF &3 EQ ' ' THEN ' ' ELSE ',' || &3;
EX CMASAP REQ_NAME=&1, CM_ASYNC=OFF, APPDIR=&2, DEP_ALIAS = DEP_1 &3;
-RUN
-TYPE (ICM18039) DEP_1 &1 Return Code = &&DEP_1_RC
-*
-* call the stats
EX ETLSM JOBNAME='&&DEP_1_ID'
-RUN
-:SKIP_ALL