Forum Discussion
Connecting Power BI to Syspro
I was a former Syspro administrator and if the back end is still just a SQL database, it would be fairly simple to do so. You would use the SQL Server connector, enter the server, select the Syspro database, enter credentials, and then either pass a query or select tables to utilize.
Yes it is fairly simple. Just by asking the question I like to know if you are a strong SYSPRO person or a strong Power BI person. If either then the answer is yes. If not then you will need help. The help you will need is figuring out the SQL database of SYSPRO then the data dictionary meaning the tables structure. Using Power BI you can just connect to SQL or use ODBC provided by SYSPRO if you paid for the license.
I was a former Syspro administrator and if the back end is still just a SQL database, it would be fairly simple to do so. You would use the SQL Server connector, enter the server, select the Syspro database, enter credentials, and then either pass a query or select tables to utilize.
thanks for the reply, I did end up connecting to Syspro via SQL Server, it was actually quite painless