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
• General Network Knowledge
• Configure Data Virtuality Server to Use a Proxy
• Setting the Server Locale for the WEEK and DAYOFWEEK Functions

See all 11 articles

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

See all 9 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
• Accessing Redshift Spectrum Tables in Data Virtuality

Working with Data Virtuality

• 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
• Sending Emails with Data Virtuality
• Selecting the Right Schema When Creating a Data Source
• Create Dependent Replication Jobs

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

See all 8 articles

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

See all 25 articles