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.
TimeXtender Tuesdays
- TimeXtender Tuesdays Live Lessons ★
- Episode 01 - Create a TimeXtender App Server in Azure (16 Mar 2021)
- Episode 02 - Configure the TimeXtender Environment in the Azure App Server (30 Mar 2021)
- Episode 03 - Use Azure Data Lake for ODX Storage (13 Apr 2021)
- Episode 04 - Use Azure Data Factory to Ingest On-Premise Data (27 Apr 2021)
- Episode 05 - Use SQL DB Serverless as DW Storage (11 May 2021)
Azure Deployments
- Use Azure SQL Single Database ★
- Use Azure Synapse SQL Pool (SQL DW) ★
- Use Azure Analysis Services ★
- Use Azure Data Lake Storage ★
- Trigger refresh or Azure Analysis Services Models built outside TimeXtender
- What is Azure Synapse Analytics?
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 Data Lake Storage Gen2 data source
- Connect to Azure SQL and Transfer Data with Azure Data Factory
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
- 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
- Improve execution times by splitting exchange rates out on dates
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
- 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