Knowledge Base
Here, we have collected frequently asked questions and guides to using TimeXtender products. Remember that you can find the TimeXtender User Guide in the Download section.
Azure Deployments
- Use Azure SQL Single Database ★
- Use Azure Synapse SQL Pool (SQL DW) ★
- Use Azure Analysis Services ★
- Use Azure Data Lake Storage ★
- What is Azure Synapse Analytics?
- What Azure SQL Database Service Tier and Performance Level Should I Use?
Administration and Settings
- Certification Exam Study Guide ★
- How to Query ODX local Backlog SQLite database
- Silent installation of TimeXtender
- Enable Remote Connections to SQL Server using IP address
- How Dynamic Ports are used during Multi-Environment transfer
- How to configure Table Partitioning
Connecting to Data
- Use Azure Data Factory for Data Movement ★
- Add a CData data source
- Adding geometry data from Oracle
- Connect to a REST API
- Connect to Azure SQL and Transfer Data with Azure Data Factory
- Connect to CSV with CData
Design, Modeling, and Transformations
- How to create a dynamic project variable
- How to use the Add Related Records feature
- How to build a Parent-Child dimension
- How to create secured views and securable columns
- How to keep track of historic data
- Custom conditions on Conditional Lookup fields
Incremental Load, Execution & Scheduling
- Incremental load method for Data Warehouses
- Execution Details SQL Query
- Creating Dynamic Data Selection Rules using Project Variables
- How to configure segmented table executions
- Improve execution times by splitting exchange rates out on dates
- Scheduled Execution issues - Did it not start, did it fail, or is my execution still running?
SSIS, Stored Procedures, Scripts & Functions
- Configure Remote Execution of SSIS Packages
- How to use a Stored Procedure
- How to use a User Defined Function
- Using TimeXtender with SQL Server Integration Services (SSIS)
- SSIS vs ADO.Net
- Use parameters in your scripts, views and calculations
Semantic Models
- Dynamic Security in semantic model setup
- Connect to Qlik Sense Enterprise
- OLAP Security in TimeXtender
- How to do a test deployment of a single cube using Offline Cube Processing (video)
- How to modify a dimension or cube using XPATH (examples included)
- How to create measure folders and sub-folders
Data Validation, Quality, and Profiling
Troubleshooting
- Activation of client version fails
- ADF execution error: ADLS Gen2 operation failed for: Operation returned an invalid status code 'Forbidden'
- Data missing or incorrect on scheduled execution with no errors
- Error Connecting to Navision Native Databases on 64-bit Windows
- Error with file or assembly DTSRuntimeWrap
- Error: "Access is denied" when deploying SSIS packages or reading objects from data source
User Portal
Release Notes
- Release Notes for TimeXtender 20.10.x
- Release Notes for TimeXtender 20.5.x
- Release Notes for TimeXtender 20.1.x
- Release Notes for Discovery Hub 19.11.x
- Release Notes for Discovery Hub 19.9.x
- Release Notes for Discovery Hub 19.6.x