2015-10-13 04:23 PM - edited 2015-12-07 11:16 AM
This ACE Data Source has been superceded by the EDM-Pack referenced here:
The attached package was a two person project. I came up with the simple idea in version 1.0 of the tool. Mirko Van Colen took the concept and made it 5-times as powerful (adding relationships) which resulted in this version 2.0 of the package.
Most WFA workflows that truely integrate with a customer's specific storage environment and business rules need to access external data (sites, cost centers, naming conventions, etc). Previously you had to write a WFA Data Source in SQL or PowerShell to import the data into WFA's database. With the ACE Data Source (i.e. ACE-DS) you simply need to create an external Excel spreadsheet and the cooresponding WFA dictionary entries. The ACE-DS does the rest reading directly from the Excel .xlsx file into a new WFA scheme and tables.
The attached files include:
- The .dar file containing the ACE Data Source and sample 'ace' scheme and tables (exported from a WFA 3.0P1 system)
- The coorsponding sample Excel spreadshee: ace.xlsx
- The User Guide covering installation, Excel-to-WFA mapping rules, and some examples.
NOTE: Attached is update to the .dar file only - Package Version Pv_2_0_1 which includes a fix for a problem if you have only one row in the excel and you work with ID’s. Docs and examples stay the same.
2015-10-14 02:50 AM
Nice post and very innovative solution.
You had a older post about using MS ACE Powershell module to acquire MS Excel data into WFA. Using Microsoft ACE for direct Excel .xlsx WFA Data-Sources
So as I understand this solution unlike the older one I just need to take care of the mapping my WFA dictionary items with the EXCEL columns. The older solution the DataSourec type code was also be be adjusted according to my Excel columns. Is this correct? Is there any other advantage?
A varient request. I see that MS Access can also maps CSV and XML into WFA DB. Can you have another version to take care of that too? The thing is MS Excel is not present on WFA server 2008, 2012 by default. CSV and XML are editable by any text editor and hence always there.
And glad to see DataSource Logger being used in your code. Hope its helping you.
2015-10-14 06:52 AM
Thanks for the feedback and good questions.
Regarding the older MS ACE PowerShell data source ...
Regarding MS Access, CSV and XML into WFA DB ...
Regarding Excel not being present/supported on Windows servers ...
DataSource Logger ...
2015-10-16 04:29 AM - edited 2015-10-16 04:30 AM
Thanks for giving time to explain it all.