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
- creating SOAP queries using SoapUI and the XML/JSON Query builder
- Connecting and querying OLAP MDX Queries
- facebook actions/conversions insights API example
- Facebook: handle paged results
- Generate base64 representation of a ( google analytics) private key (p12) file
- Create Analytics Service Account for Connection
Non-Web Service based Data Sources
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
- manual start of dependent schedules
Connecting Frontends
- Connecting Tableau via ODBC
- Connecting F# via ODBC
- Connecting Excel via ODBC
- Connecting Qlik via ODBC
- Connecting SQuirreL via JDBC
- Connecting Data Virtuality Server from Python using JDBC Driver and JayDeBeApi
Cookbook Recipes (Snippets)
- Using TEXTTABLE to implement SPLIT / SPLIT_PART
- Detect the encoding of a file via custom procedure
- CSV Export with filter
- Regex_Replace via ObjectTable
- Send mail with file attachments
- Email notification with editable FROM- adress