Analytics » What is Reporting Database » New Reporting Database
Often you already have data locally stored in tabular file formats like CSV, XLS/XLSX (Excel), XML, JSON and HTML files, which you would like to import into Virtutem Analytics for analysis and reporting. In Virtutem Analytics you can easily import your data in such file formats and jump start your activities.
Click the Import from Files and Feed option to create a database by importing data. Follow this link to read more about creating a database using this import data option.
You can also create database by importing data from a cloud storage like Google Drive, Dropbox, Box and OneDrive. Click the Import from Cloud Storage option to create a database by importing data. Follow this link to read more about creating a database using this import data option.
In case you maintain your data in your database such as MS Access, Microsoft SQL Server, Oracle, MySQL, Sybase, PostgreSQL SQLite, DB2, DB2 AS/400, and other applications behind firewall or in a cloud database such as SQL Azure, then you could synchronize data from your databases into Virtutem Analytics reporting database using our Upload Tool. The Upload Tool is a downloadable standalone utility, that enables you to upload data from your databases into Virtutem Analytics reporting database.
Using Upload Tool you can pull data from application databases behind firewall and cloud database to upload the same into Virtutem Analytics. The tool directly accesses your database, queries for the required data and uploads it to Virtutem Analytics Upload Tool also allows you to automate the import process in a scheduled interval. With this your reporting database will be updated with latest data without manual intervention and thus keeps your reports and dashboards latest for better analysis.
To know how to fetch data from your database using Upload Tool, refer to the Upload Tool section.