Using an oData source for filling lookup tables at install

[visualsi]

We want to install applications that will have an accompanying database that has very large local lookup tables. We want to fill them at install time from an oData (web service) source instead of using SQL scripts because the installer can't handle SQL scripts this large (and if we broke them up into the size the installer could handle, we would need to maintain several hundred scripts or more).

Having the installer call an oData web service would simplify this so that we would not need to maintain any data-related SQL scripts, just a master database with the correct values in it. The users would always have access to the most up-to-date values from the master database.

Has anyone done something like this? ...or, is there already a facility in Advanced Installer for doing this? A generic facility (not needing to write new code for each table being populated - just recording configuration information) would be best.

Thanks,
Rob

[Daniel]

Hello Rob,

I'm afraid we don't have predefined support for this. Also, since it wasn't requested until now we don't have any examples about how to achieve this. As a workaround, you can create your own custom action which will call an OData web service. You can take a look on "OData Services" article which may be useful for you.

All the best,
Daniel