Data Transfer from DBMS to EAP Automation

[GraemeR]

Hi Guys,

Does anyone have a VB Script (or similar) that can be used to automate the process of Data Transfer from DBMS via ODBC client to a .eap file.

Cheers Graeme.

[Bruno.Cossi]

.EAP file is nothing but an MS Access file with its extension changed. Transfer of data would be nothing but an export of data from tables in the ODBC database and their import to MS Access.
If you need more help, I would be more than happy to put a script together for you.

Bruno

[GraemeR]

Hi Bruno,

Currently I do a backup of an EA model from a MySQL Database to a .eap file each morning using the EA Data Transfer mechanism, which, of course, is a manual process.

1. I would like to get a VB Script that I could simply plug in the Connection string of the source model, and the path and filename of the target model. Running the script would effect the transfer of the data.

2. The script would need to be able to handle the case where the source model requires "admin" user access and a password to use Data Transfer.

3. Handy additions would be the ability to do the following.

(a) Iterate over a list of source:target pairs, performing data transfer for each pair.

(b) Rename the newly populated target Model .eap file according to a specified current date format of "ddmmmyy" (eg 09Mar04.eap) and add it too a specified WinZip (.zip archive) file, then delete the .eap file.

(c) Copy an empty project file over the original target model to allow for the next days backup.

Such a script could be scheduled to run at a specific time each time.

Would this be an interesting challenge for you?

Any help you could give would be much appreciated.

Cheers Graeme