Running Vision here, projected GO Live September 1st 2025.
We have access to our compass data through .csv files exported every night when compass is updated with the day’s new data.
We need to import this data into our local T-SQL server. As anyone here done this?
We would like to use SSRS to generate reports as Compass does not fill our needs.
Any help would be appreciated.
Lots of ways to do this… Can Compass push data via API?
Only CSV - then you could set up a scheduled powershell script, or a 3rd party directory watcher - such that either will find the CSV file dropped into the folder and execute a DMT process to load the file into a UD table. Then you can build a SSRS report on the UD table.
The nightly Compass updates also extracts all data as .csv files.
I was wondering if someone had already done this as we are apparently not the only customers who get those data extracts, and share their process to help us out.
Our setup is hosted at Epicor, we need to figure out how to get the csv files into our local server first.
We need to know what the mapping is for all those CSV files and then we need to build some scripts in SQL to insert/update data from the CSV files into their respective Tables in our SQL database.
Thats a lot of work in front of us and little time between now and our Go Live.
Thanks for your input, very much appreciated.
Good Luck!!
Thanks!!