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.