How-To Guides
Installation
Maintenance and Monitoring
- Backup and High-Availability Options on AWS
- Changing Directory of Temp Folder
- Switching the Internal Configuration Database to PostgreSQL
- General Network Knowledge
- Configure Data Virtuality Server to Use a Proxy
- Setting the Server Locale for the WEEK and DAYOFWEEK Functions
Web Service based Data Sources
- Google Analytics: How to migrate from Reporting API v3 to v4
- Creating SOAP Queries Using SoapUI and the XML/JSON Query Builder
- Connecting and Querying OLAP
- Facebook: Handle Paged Results
- Generate Base64 Representation of Private Key File for Google Analytics
- Create Google Analytics Service Account for Data Source Connection
Non-Web Service based Data Sources
Working with Data Virtuality
Connecting Frontends
- Connecting Data Virtuality Server from Python using psycopg2
- Connecting Tableau via ODBC
- Connecting F# via ODBC
- Connecting Excel via ODBC
- Connecting Qlik via ODBC
- Connecting SQuirreL via JDBC
Cookbook Recipes (Snippets)
- Using TEXTTABLE to Implement SPLIT / SPLIT_PART
- UPDATE statement with two tables
- CSV Export with Filter
- Regex_Replace via ObjectTable
- Send Mail with File Attachments
- Email Notification with Editable FROM Address