Skip to main content
To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about TimeXtender Data Integration and TimeXtender Classic desktop applications

742 Topics
K
Contributor
KajEmergoContributor
asked in Prepare
Audit trail modified GDPR-related objects

Hello,In order to be able to answer all related questions regarding GDPR, we are designing a TX solution that allows us to track all tables/columns that contains sensitive information. Most importantly, we make use of tags so we can track the columns throughout the DWH.An additional question we got is if it is possible to keep track of changes in the TimeXtender projects. In other words, who added which column (with sensitive data) to the project and when? What is the best way to keep track of these things and is there a solution in TimeXtender available that we can use to provide this information? Probably we should use the data in the TX Repository, we were curious if you have had this question before.

802
K
Contributor
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Prepare
Incremental load without primary key

I’ve some tables in my data source without primary key, but I’ve a MODIFIEDDATETIME field for all the records, that it can be used to incremental load, but TX doesn’t allow it.Some workaround? 

3354
Thomas Lind
Community Manager
M
Starter
malknStarter
asked in Deliver
Multiple semantic layers

We using multiple semantic layers, and adding more in the future. All semantic layers will probably need a calendar dimension and some other dimensions are also shared between layers. Is there any 10x  method to copying between semantic layers, as it seems quite ineffective to setup:sort bysummarize bycategoryn-times on the same table

1651
Thomas Lind
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Prepare
Setup TX for multiple developers

What it’s the recomended setup in the new version to support multiple developers and multiple projects?How many ODX instances, MDW instances must we would use?

843
Thomas Lind
Community Manager
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in Ingest
Upgrading data source provider version

TX: 6143.1 I have a TimeXtender SQL Data Source version 17.0.0.0 that I am trying to upgrade to 17.0.0.1. When I do Manage Data Sources in the ODX Server from the TimeXtender application it tells me there is an update available. When I apply this it tells me to ‘Edit the datasource’ to update the connection string. There does not seem to be an obvious way to do this. The User Portal also does not seem to have a way to update this.What is the process I should apply?

882
S
Contributor
V
Participant
VictorParticipant
asked in Prepare
Incremental load with Table Inserts and Views

Hello,Current Setup: TimeXtender 20.10.31.64 and ODX 20.10.31.I need help setting up incremental load on a rather different type of data flow from the standard one, that has table inserts and views inbetween tables.The flow is as follows:Table A (has incremental load today) => View1 => TableB => Table C(MDW) once directly but also through View2.Both views are necessary so we cannot remove them.  My question is how to setup incremental load in timextender on this solution, if it is even possible. I am not sure how to do it through a view. Currently there is only an incremental load set up on Table A and then we fully load table B and C. Thank you

2643
Christian Hauggaard
Community Manager
S
Contributor
sguntupalliContributor
asked in Ingest
datediff function resulted in an overflow

Hi,I am using the ODX server to get data from the SQL server database.After executing the transfer task, I am getting the below error.Any idea how to solve this?“System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.”

3073
Christian Hauggaard
Community Manager
T
Starter
TamimStarter
asked in Ingest
ODX mapping ussue

Hi Support,We are using an ADO Data Source connection to load data in the ODX into Azure.From there we map the ODX table to the next layer in TimeXtender.This seemed to work.But now we changed the source table with added and removed columns.We sync and transfer it in the ODX and when we use preview in the ODX we are seeing the new table as expected. But when we map it in TimeXtender again to the next layer, the changes are not added. It instead maps to what is used to be. It mappes fields to columns that no longer exist, and it does not map the new added columns.We tried clearing the files in Azure to start fresh but it still mappes to the older version that no longer exist. Why would it still mapp to the old table that no longer exist in the source and no longer exist in Azure?Why would it not mapp to the new table thats in Azure now?Is there some metadata in TimeXender that first has to be cleaned before changes can be mapped?Kind regards,Tamim 

772
T
Starter
K
Contributor
KCMTContributor
asked in Prepare
History Table not deploying anymore 'SCD Type I Hash Key' Error

After attempting to add a new column to my history table, I cannot get the table deployed and executed anymore. The new column is currently not in the table, but I also can't get it to get back to "old" historical table back without the new column. Currently have tried the following things, but so far without result:Set the project version back to an earlier version where the change wasn’t made yet; Upgrarde the PROD SQL DB Size and deploy again.It does not get beyond the Valid Table structure when deploying the historical table. When previewing I also get the following error messages:The table you are trying to preview has not been deployed yet. Deploy first.Invalid column name 'SCD Type I Hash Key'.   The table you are trying to preview has not been deployed yet. Deploy first. Invalid column name 'SCD Type I Hash Key'. Details: SQL Server: 'c5d03ed4f0ca.tr30953.westeurope1-a.worker.database.windows.net,11052'SQL Procedure: ''SQL Line Number: 1SQL Error Number: 207 Invalid column name

1368
K
Contributor
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Ingest
Dynamics 365 F&O Data Lake as a TX source

We are planning to use  Export to Azure Data Lake feature in D365 F&OMy question it’s:How can connect to the Data Lake from TX?Or, we can connect to Synapse Analytics?How can we make the data source setup in TX?

56315
rvgfox
Problem Solver
ignacio
Contributor
ignacioContributor
asked in Prepare
How to create a union Table in DSA

I have the following code y DSA:Select * from TableA union Select * from TableBunion Select * from Table CI want to replace this code with a table

2264
ignacio
Contributor
K
Contributor
KajEmergoContributor
asked in Ingest
Extract CSV from SFTP with public key authentication

We have a SFTP source on which CSV files are stored and which can be authenticated to with a ‘public key’. When using the CData SFTP-connector in ODX Server, we are able to connect with the following settings: The most important setting here is the SSH Auth mode, where we specify that we are using PublicKey authentication. Since I am not familiar with this type of connector, I would not now how to retrieve the data from the CSV files (the only table we get from the source now is the ‘Root’ table that contains the FileNames that can be found in the folder).I would rather use the CData CSV-connector, but that leaves me with a problem when testing the connection: I cannot specify that I want to use the PublicKey authentication mode. That is, it is specified under ‘SSH Auth Mode’ but it is not possible to select under ‘Auth Scheme’: As a result, we keep getting the same error on testing the connection (see attached file). I have tried setting the Auth Scheme to ‘None’, ‘Auto’, ‘SFTP’ or ‘B

2113
Thomas Lind
Community Manager
K
Contributor
KajEmergoContributor
asked in Prepare
ADF pipeline run fails with empty configuration

Hi,We are receiving some weird error messages when executing our project, which uses Azure Data Factory to copy tables from our Data Lake storage to the Azure SQL db (ODX → DWH). The error can be found in the attachments. When inspecting the pipeline run on ADF, it seems to be missing the configured activities (see second attachment). When executing the table manually from TX, the pipeline runs succesfully. Also the pipeline seems correctly configured on ADF and the pipeline run that is created when executing the table manually shows the correct activities.Any ideas as to what might be causing this? Best regards,Kaj  

40412
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Ingest
Excel files in SharePoint

I’ve three excel files in a SharePoint folder:Budget Forecast Price ListWhat it’s the best option to get the files into a TXA DSA?Can you provide me with detailed instructions? 

1773
Thomas Lind
Community Manager
L
Participant
luuk.boumanParticipant
asked in Jobs & Executions
Chain of execution packages are not able to run concurrently

We are seeing a situation where the next scheduled execution of a package does not start and the event is logged that this is because the previous execution is still running. However, when we closely look at finish times for these executions, the actual finish time is on average 8 minutes before the start of the next execution. I've been told that there can be a delay of a couple of minutes between the task itself actually finishing and the moment the process that executed the task is ended as well. However, 8 minutes and sometimes even up to 13 minutes seems too long.Anybody any ideas on why this occurs and what could be done about it? We're currently running TX version 20.10.25.

35214
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Prepare
Add custom table insert feature

Can you explain how and for what it can be used?

3666
tld
Contributor
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Prepare
Revese Data Area feature

Can you provide some documentation about this?How can I use it?For what it must be used? 

812
tld
Contributor
L
Contributor
LorenzoContributor
asked in Deliver
Change schema in Data Export

Hi,The current Data warehouse has tables with two different DB schema's. There are already PowerBI Dash-boards using these schema's. Now I want to use the Semantic layer to copy the data (Data Export) to a SQL serverless DB. Everything works fine but I want to override the schema name. In the Semantic layer I have not find any options to change this. Is that correct or is there a way like in the Dataware house layer to change the schema?

1183
Christian Hauggaard
Community Manager
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in Deliver
Qlik Sense Enterprise endpoint cannot create/modify a Data Connection

TX: 20.10.39SQL Server: 2019Endpoint settings:Windows authentication hostname matching case https connection over the default proxy I am trying to push a Qlik Sense Enterprise endpoint from TimeXtender and having trouble getting the deploy successfully running. Testing connection to Qlik Sense is successful, when I Deploy I get an error when TX tries to create a new Data Connection. I see this issue pop up sometimes in other deployments and can usually overcome by manually making a Data Connection to the MDW database and giving it the same name TX would use: MDW_SLQV . In this case, I get the same error when TX tries to modify the connection.TimeXtender does create the app (and is owner of it) and can successfully reload the app, it just doesn't insert the script. If I copy-paste the TX Qlik Script into the app it works fine. As neither TX nor Qlik actually log what is going on, I cannot see what about the connection string is causing the error.

4849
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Prepare
Copy between instances

When you arte coping between instances, the destination insatance name doesn’t show complete. 

480
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Prepare
TX allows to add data selection rules over calculated fields but gets an error in execute

As you can see in the screenshot, I think that this situation must be controled: 

506
rvgfox
Problem Solver
R
Starter
richardrayStarter
asked in Prepare
Troubleshooting data cleansing rules

v20.10.36.64Hi,I have a project that is loading data from the ledger table into the staging database with approx, 5m records.When manually executing the load, the ADO.NET transfer is taking 5-6 minutes, but the cleansing rules can take hours, to the point I have to terminate the load.Is there any troubleshooting I can perform on the cleansing steps? I know I have taken the easy option on joins where the data types differ, and wonder if that is now compounding the issue?Any tips or pointers greatly appreciated.Thanks,Richard

4982
R
Starter
L
Contributor
LorenzoContributor
asked in Prepare
Range lookup

Hi,I would like to do a “range lookup”. Because I can't solve it using a conditional lookup, I used a custom field transformation. My code looks like this:CASE    WHEN substring([SBIcode_cleansed], 1, 1) like '[^0-9]' THEN                    (SELECT [kvk_groep_omschrijving]                     FROM  [dsa].[SBIcode_groepering]                             where [SBIcode] = [SBIcode_cleansed]                   ) --'test1'   ELSE                   (SELECT [kvk_groep_omschrijving]                     FROM  [dsa].[SBIcode_groepering]                            where substring([SBIcode_cleansed], 1, 2) >= [min_sbi_code]                              and substring([SBIcode_cleansed], 1, 2) <= [max_sbi_code]                   )--'test2'   END It seems that a subquery is not possible because I get an error message that more than one value is retrieved using the subquery but that is not possible.Testing it in SSMS works fine. (Not using between because above seems to work faster when testing

1436
rory.smith
TimeXtender Xpert
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Deliver
Incremental refresh for XMLA Power Bi semantic models

Until I have started using TX, I am setting up my PBI import datasets using incremental update as you can see in:https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overviewNow, in TX, how can this be accomplished?

2768
rvgfox
Problem Solver
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Prepare
Adding a new field to an existing table with data

If you add a new field with the deploy only option, to an existing table with data, there are two diferent behaviors, depending if the table has incremental rule defined or not.This is controled by this setting: By default it’s cleared for “normal” tables and setted to incremental tables.I think the behavior should always be the same or at least get a warning message

380
rvgfox
Problem Solver

Badge winners

Show all badges
Terms and ConditionsCookie settings