How-To Guides

Installation

• Best Practices Operating Data Virtuality on Linux
• Launching the Data Virtuality AMI on AWS

Maintenance and Monitoring

• Backup and High-Availability Options on AWS
• Changing Directory of Temp Folder
• Switching the Internal Configuration Database to PostgreSQL
• Setting the Server Locale for the WEEK and DAYOFWEEK Functions
• Backing up and Restoring Databases
• Backup/Restore of your Data Virtuality Configuration

Web Service based Data Sources

• Transition from AdWords to Google Ads API
• 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

See all 10 articles

Non-Web Service based Data Sources

• Partitioning Tables in BigQuery
• Parquet File Creation and S3 Storage with Data Virtuality
• Query Parquet Files in Data Virtuality Using Amazon Athena

Working with Data Virtuality

• Permissions for developers in AD+DTAP scenarios
• Replicating to non-DWH-datasources
• Find Enabled Recommended Optimizations Which Have No Schedule
• How to run vulnerability scans in Data Virtuality
• Recommended firewall settings for an on-premise installation of Data Virtuality
• Disabling Data Virtuality ports

See all 11 articles

Connecting Frontends and Applications

• Connecting C# via ADO.NET
• Data Virtuality Power BI Custom Connector
• Connecting F# via ODBC
• Connecting Excel via ODBC
• Connecting Qlik via ODBC
• Connecting SQuirreL via JDBC

See all 7 articles

Cookbook Recipes (Snippets)

• Bulk Excel Loader
• Using TEXTTABLE to Implement SPLIT / SPLIT_PART
• UPDATE statement with two tables
• CSV Export with Filter
• Email Notification with Editable FROM Address
• CSV Export with FTP Upload

See all 21 articles