Multiple Vendor Databases with Snapshot

Multiple Vendor Databases with Snapshot

You can run multiple Vendor Databases with Snapshot

Let's take ABM as a Vendor - let's describe the options:

If it is NOT required to have multiple ABM databases be used in Snapshot simultaneously by users (in other words only one ABM database to be accessed at a time by all users) then you can just have one install of Snapshot and change the ABM database on the settings screen (Update Business system Database Connection) of Snapshot, then check for new dashboards to make sure all views are up to date for the ABM database. 

If you wish to have multiple ABM databases accessed at the same time then you will require an install of Snapshot into their own directories using the Stand alone mode per instance of ABM database. This will also require a Snapshot database per install and a licence per install. There is a file that will be located in each install folder based on the Stand alone setting that stores which Snapshot database to be used and it's the Snapshot database that stores the connected ABM database and dashboards for that database. 

Databases other than a supported business system.

This will require using a Snapshot setup that logs into one of the ABM databases as Snapshot requires a business system type and a database to be selected. Once in Snapshot you can make use of the Custom Connection strings to connect into any other database. Custom dashboards can then be created using the custom connection string.

    • Related Articles

    • Reporting across Multiple Companies in Snapshot

      With just one log in, you can report across multiple companies through Custom Dashboards. The two main ways to achieve this is to either make use a view that references the names of the database and table name or to use Custom Connection strings. ...

    • Showing data from multiple databases in one dashboard within Snapshot

      Yes, it is possible to have data from multiple databases in one Dashboard. Your Partner or Plus Software will need to add your Data Source (in your Dashboard Designer), then choose fields and build Dashboard items into the Dashboard. For assistance ...

    • Reporting across other databases within Snapshot

      You can report across any SQL or other database from within the same Snapshot login. The custom connection strings under Settings is used by Plus Software and Partners to pull data from multiple different sources / databases into one Dashboard. Ask ...

    • Running Snapshot across different database types

      You can run Snapshot for different database types, e.g. Sage Evolution and Ostendo which use Microsoft SQL and Firebird, respectively You would just need a Snapshot install and Snapshot database per different database type. Ask your Partner or Plus ...

    • Custom pass through parameter with multiple values

      When in the Snapshot Dashboard Design mode, you can have a pass through parameter that has multiple values within Snapshot Business Intelligence. For example you may have a Sales Rep dashboard and a specific rep may have 2 rep codes. You can pass ...