How-To Guides

Installation

• Updating Data Virtuality Platform license for on-premise servers
• 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
• 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 perform quality control and 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 PySpark via JDBC using Jupyter Notebook
• Connecting C# via ADO.NET
• CData Virtuality Power BI Custom Connector
• Connecting F# via ODBC
• Connecting Excel via ODBC
• Connecting Qlik via ODBC

See all 8 articles

Cookbook Recipes (Snippets)

• Bulk Excel Loader
• Using TEXTTABLE to Implement SPLIT / SPLIT_PART
• Avoiding SQL Injection attacks using procedures
• Snowflake: working with multiple warehouses
• UPDATE statement with two tables
• CSV Export with Filter

See all 23 articles