Rank: Member
Joined: 3/6/2018 Posts: 28
|
Hi All,
Can we pass connection string parameter to sql server database mapping in mapforce. Is there something like we can create connection string parameter in flowforce server job and pass it to mapforce database mapping.
Thanks
|
Rank: Newbie
Joined: 10/28/2002 Posts: 1,283 Location: AT
|
Hi,
no. What you could do though is to use global resources in your mapping.
This will not allow you to specify a truly dynamic connection string, but you will at least be able to choose from a number of different connection strings, not just the one used to insert the database component into your mapping design (.mfd) file
If you use global resources you would have to compile your mapping to a Mapforce Server Execution File as opposed to deploying it directly to Flowforce Server (because Flowforce Server does not support global resources but Mapforce Server does).
You would compile your mapping to an mfx file (File / Compile to Mapforce Server Execution File) and then in Flowforce Server you would create a job with a step which uses the command line function.
The command you would use calls MapforceServer to run the mfx file using one of the global resource aliases in the specified global resource configuration file e.g.:
Code: C:\Program Files (x86)\Altova\MapForceServer2018\bin\MapForceServer.exe run SomeMapping.mfx --globalresourcefile="C:\Users\me\Documents\Altova\GlobalResources.xml" --globalresourceconfig="Default"
|