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

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

Working with Data Virtuality

• Replicating to non-DWH-datasources
• Find Enabled Recommended Optimizations Which Have No Schedule
• Using the Upsert Stored Procedure to Reproduce the SQL MERGE
• Using S3 to Ingest Data into Redshift
• Selecting the Right Schema When Creating a Data Source
• Create Dependent Replication Jobs

Connecting Frontends

• Connecting F# via ODBC
• Connecting Excel via ODBC
• Connecting Qlik via ODBC
• Connecting SQuirreL via JDBC
• Connecting R via JDBC

Cookbook Recipes (Snippets)

• 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
• Pass Key Value Pairs to a Procedure Using Multi-Dimensional Arrays

See all 20 articles