...
Sage50_Connections.exe
This is to set up the credentials being used for SQL Server and Sage 50
Sage50_ETL.exe
This is the process that will copy the data from Sage 50 and move this to SQL Server making it relational and accessible by pi
Sage50_Repos.sql
This is the preconfigured dashboard repository that is to be restored into pi
Sage50_Script.sql
This is an SQL file that the ETL process uses each time it runs
Sage50_Views.sql
These are SQL views that have been created for some of the more complex calculations required for the dashboard and are checked each time the ETL process is run
Exclude_Tables.txt
This is a config file containing a list of tables from Sage 50 that are excluded from the ETL process as not required in the default build. If a table is required then it can just be removed from this file, alternatively a table can be added to this file if you require it to be excluded
PIDataSources.txt
This is used to list the data source name of the ODBCs that are used for the data transfer
Please refer to the following sections for more instructions:
| Child pages (Children Display) |
|---|