VIA Data Query only provides a single username and password for connectivity per tenant.
If multiple users are to use the data provided by VIA Data Query, it is highly recommend that a local copy of the VIA Data Query database is kept.
- Faster Local data processing
- Granular Local User Control
We recommend using Sql Server Integration Services (SSIS) to run a scheduled job to import data to your local (or cloud based) database system.
SQL Server Analysis Services (SSAS) can also be used to import and manage data from VIA data Query.
For more information on importing data using SSIS or SSAS please contact your database support provider.