This content has been marked as final. Show 2 replies
I have a model that I have setup an external lookup with ODBC connection and use a specific table. This works great for the extract for this specific institution that it was setup for, but because each institution has their own database; it obviously does not work for the others.:(
The extracts are intended to be done in a batch fired from a Scheduler, so it already knows which institution it is creating the extract for, so I thought of using the /datasource command line parameter. The problem is that I am not sure what I need to enter at that point (do I enter exactly what is in the Data Source[/B] textbox in the External lookup?).
Here is what I have done:
What needs to change is the DATABASE=RFS[B][I]xxx[/I][/B] part of the string. Everything else is identical, even the field names within each identically named tables of each database.
To invoke monarch I did the following:
If I look at the data, the field that is used in the lookup simply returns NULL because it does not match the data.
I saw in another [URL="http://www.monarchforums.com/showthread.php?t=1486&highlight=%2FDATABASE_NAME"]thread[/URL] that the option /DATABASE_NAME was used, but I cannot find any documentation on this option.
Am I going about this the right way? Any other suggestions?