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
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
- Add a CData data source
- Adding geometry data from Oracle
- Authenticate using OAuth 2.0
- Connect to a REST API
- Connect to Azure Data Lake Storage Gen2 data source
- Connect to Azure SQL and Transfer Data with Azure Data Factory
Design, Modeling, and Transformations
- Create a self-join table using Custom Views
- 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
- Custom conditions on Conditional Lookup fields
Incremental Load, Execution & Scheduling
- Configuring ODX Scheduled tasks ★
- Memory limit restraint of parquet file extraction
- Incremental load method for Data Warehouses
- Execution Details SQL Query
- Creating Dynamic Data Selection Rules using Project Variables
- How to configure segmented table executions
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
- SSAS Multidimensional 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
- Self-Service Troubleshooting in TimeXtender ★
- 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
TimeXtender 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