Occasionally it is required to administer the analytics extract process by running a query on the SQL Database to check that the data has been transferred. Querying the SQL database can be done from within ERP+ without a need to connect to SQL Server management studio. This is helpful if a user does not have access to SQL server.
The query result can be exported to an Excel spreadsheet, should that be required.
SQL Editor
