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

728 Topics
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in Prepare
New version of TimeXtender?

I have just downloaded the ODX Server and TimeXtender and it looks like TimeXtender has a new version: 6534.1 are there release notes coming for this?

621
J
Contributor
P
Explorer
PepijnExplorer
asked in Deliver
Can I connect one semantic model to multiple PowerBI workspaces?

Hi everyone,I’m coming across some specific drawbacks of using the semantic models in TimeXtender in combination with PowerBI. I hope this is due to my lack of understanding or design choices and hoping it can be fixed.While working OT(A)P (DEV / TST / PRD) we have found that looking at the development environment with PowerBI is too much of a hassle, too many changes, wrong data, just too much development to keep up in the semantic models and PowerBI is not flexible when it comes to name changes etc.We decided to delete the semantic models from DEV and start building the model in TST. (For early data exploration we can still build the model in PowerBI itself on the MDW). In PowerBI we use the pipelines and we can connect TST-TST and PRD-PRD. But what would be even better is connect a PowerBI DEV workspace to TST, and the PowerBI TST and PRD workspaces to the PRD endpoint so that we can test the dashboard on production data, give it the green light and there is no risk of any differenc

7054
Christian Hauggaard
Community Manager
avanrijn
Contributor
avanrijnContributor
asked in Deliver
Scheduled package fail for semantic model

Dear Sir,Our customer has an issue for scheduled semanctic models.ODX and DWH instances run succesfully when scheduled, but the semantic models are not running.The semantic model is running successfully by hand, but when the package is automated in a scheduled setting the package execution fails. Execution overview SemanticError semanticHopefully you can shine a light on this issue. Our client is running TimeXtender version 6436.1.Regards,Arthur van RijnFourpoints 

1297
avanrijn
Contributor
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in Ingest
Microsoft Dataverse Connection

Hi, I have created and populated a small table in Dataverse using a Power App.There are no problems accessing and reading data from the table with Power BI Desktop.But I don't really understand how to use CData's connector (Microsoft Dataverse (23.0.8749.0) 64bit). Does anyone know which fields to fill in for the authentication itself? Username and password or equivalent. BRAnders

3143
Christian Hauggaard
Community Manager
K
Contributor
KarankadamContributor
asked in Prepare
Fetching information from Tables

As shown in figure, Sales Ord Is My Base Table, and second table is Sales_ORD_LN_PROD_FAM,what i want to do is, Fetch PROD_FAM_NO,SALES_ORD_LN_NO column in to Sales Ord Table,Sales_Ord_No is same column in both Table,Is there any way to do it,

713
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
asked in Prepare
Using very big tables

I have a very big table with millions of records.I’ve divided it in three mappings : aggregate, historical and current.If I need to do a full load only for the current mapping, what can I do it?

1133
Christian Hauggaard
Community Manager
P
Contributor
pontus.berglundContributor
asked in Ingest
Read latest CSV file (from S3 bucket)

Hi,I have a working connection to an S3 bucket with CSV files, using the CData CSV connector.I would like to create a solution where I read only the latest file added to the bucket.Calling the stored procedure “ListFiles” (https://cdn.cdata.com/help/RVJ/ado/pg_sp-listfiles.htm) in a query table returns a table of the files, with filename and created timestamp.Is it possible to call ListFiles in an .rsd file? If so, I think it would be possible to access the created timestamp in another .rsd file using a query slicer which can be used to get the latest file.Have anyone solved this problem, or something similar? I am using the latest version, 6512.1. 

26310
Christian Hauggaard
Community Manager
rvgfox
Problem Solver
rvgfoxProblem Solver
posted in Deliver
TimeXtender enhancements

I share with you a document and a video to show the problems I have found in TX and suggestions for improvement.In the video I’m showing how to use Tabular Editor to solve the problems. Show my video

450
rvgfox
Problem Solver
K
Contributor
KajEmergoContributor
asked in Ingest
ADF - PostGreSQL 'queryTimeout' error

We are using the Azure Data Factory - PostgreSQL 14.0.0.0 data source connector and cannot run the synchronize task. We have selected ‘All tables’ in the data source setup but get an error in ADF:“Failure happened on 'Source' side. ErrorCode=UserErrorInvalidValueInPayload,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to convert the value in 'queryTimeout' property to 'System.TimeSpan' type. Please make sure the payload structure and value are correct.,Source=Microsoft.DataTransfer.DataContracts,''Type=System.ArgumentException,Message=Object of type 'System.Int64' cannot be converted to type 'System.String'.,Source=mscorlib”The error seems to be related to the ‘Command timeout’ setting in the TX portal, which we set to 1440 but ADF wants it to be a ‘System.TimeSpan’ type?When we want to use ‘Select tables’ on the ODX data source the screen runs ‘Search tables’ for a split second and then the results remain empty, no tables appear at all.The Linked Ser

972
K
Contributor
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Paul McLeod Bespoke AnalyticsTimeXtender Xpert
asked in Ingest
V20 ODX loosing Meta Data for REST data source

I have a rest interface loading via ODX in V20 into an Azure Data Lake.Recently an infrastructure change to the server made the Rest Endpoint timeout (it has an IP whitelist and the server IP was removed).This resulted in the Synchronization task determining that there were no tables available to load, even though there are multiple custom RSD files that have been generated and the CData Rest driver has been configured to Never generate Schema files. The IP has been restored to the whitelist and the Rest interface is working again (after multiple days of the ODX loading nothing). Unfortunately the Meta Data for every table has been flagged as invalid. When I run the ODX load every table comes back with an error that the table has already been used by a table with a different GUID. And If I run the synchronize task on the ODX it deletes the mapping of every table connected to the particular ODX source (40+ tables).I cannot even run a preview of the data from the Gen 2 storage through Ti

514
Paul McLeod Bespoke Analytics
TimeXtender Xpert
O
Explorer
ofirbExplorer
asked in Ingest
ODX in faulted state

Hello,Our ODX gets stuck whenever we make a request to it (be it synch, transfer, or viewing a log). Then we see the error message in attachment and usually we see a second ODX all of the sudden. Any idea what may be causing it? 

1874
rory.smith
TimeXtender Xpert
A
Problem Solver
aftabpProblem Solver
asked in Jobs & Executions
Exclude tables from an Execution package

I have set-up an Execution job that builds a table based on a view. The view generation is in DSA. The tables in the view have saperate Execution package that runs (before this job) without failing.Because of the limitations on how often the data can be extracted with API-endpoints in DSA_ tables, the following Execution job failed previously.I wanted to exclude the tables that are already updated so i have defined the tables that i dont want to run. Is this the right way to do it?    

1174
Thomas Lind
Community Manager
M
Visitor
magnus.jorstadVisitor
asked in Ingest
ODX Server timestamp

Is there a way to get the timetamp of when a table was transferred from source to ODX Server? Like the DW_Timestamp. The only system field i can find is odx_batch_number. 

1685
Thomas Lind
Community Manager
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in Jobs & Executions
Execution Package Unknown/Running and never Finished

The daily build of a data warehouse started for an Execution package but never finished. I am unable to see any cause of this job stopping in the TX logs or Event Viewer (Unknown_Running.png) of the server. Is there somewhere else I can check to determine the cause of the build to cancel while running for no reason?Since there was no direction to resolve this issue, we left the build to try to run again today and are now receiving an error that says the job is currently executing (Warning.png). How do I clear this stuck job in TX? 

3523
kerry_bespoke
Contributor
K
Contributor
KarankadamContributor
asked in Prepare
SQL Snippet Error

CREATE VIEW [Demo].[INVC_T] AS    SELECT        R.[ACCT_DT],        R.[SPLIT_FROM_INVC_NO],        R.[REMIT_TO_ADDR_NO],        R.[USER_INVC_NO],        R.[UPDT_PERS_NO],        R.[UPDT_DT_TIME],        R.[TOTALS_UPDT_DT_TIME],        R.[SHIP_TO_ADDR_NO],        R.[SEG_NO],        R.[RECUR_INVC_NO],        R.[PRINT_INVC_STATUS],        R.[PMT_TERMS_CD],        R.[JE_NO],        R.[INVC_TYPE_CD],        R.[INVC_STATUS_CD],        R.[INVC_SRC_CD],        R.[INVC_NO],        R.[INVC_DUE_DT],        CAST( ([INVC_DT]) >= DATEADD(week, -10, GETDATE()) AS datetime) AS [INVC_DT],        R.[INSUR_AMT],        R.[FRGHT_AMT],        R.[CUST_TYPE_CD],        R.[CURR_RATE],        R.[CURR_CD],        R.[CLOSE_DT],        R.[BILL_TO_CUST_NO],        R.[ACCT_YR],        R.[ACCT_PER],        R.[PMT_METH_CD],        R.[CREDIT_CARD_FLAG],        [DW_Id],        [DW_Batch],        [DW_SourceCode],        [DW_TimeStamp],        [DW_ODXBatchNumber],        [DW_ODXBatchId]    FROM        [Demo].[INVC_R]

2018
Christian Hauggaard
Community Manager
P
Contributor
pontus.berglundContributor
asked in Ingest
SQL Database cleanup tool for ODX

Is there a way to remove tables from ODX storage that have been deleted in the desktop, similar to the SQL Database cleanup tool available in the DW? My use case is when SQL Storage is used for the ODX.The “Remove unused object” option does not drop tables it seems. The Storage Management Task is good of course, but we can’t use it for deleted data sources.Let’s say I have transferred a large table hundreds of times into my ODX and then deleted the data source. Can I remove them without having to drop the tables manually in SSMS?Best,Pontus 

1223
P
Contributor
R
Participant
RobertUParticipant
asked in Prepare
Error using data selection rule in DSA with data source ODX server

We are just started to use ODX server as a source for our countries that are migrated to Business Central in Azure. On our DEV environment i want to limit the data to only get entries after a certain date. Normally i would use a data selection rule on Posting Date Greater or Equal 2021-01-01When i want to do that on ODX server as a data source i get:Conversion failed when converting date and/or time from character string.I have tried every date notation i can think of but i always get this same error.Anyone any idea on how to filter dates from the ODX Server?

31033
Thomas Lind
Community Manager
bas.hopstaken
TimeXtender Xpert
bas.hopstakenTimeXtender Xpert
asked in Ingest
PK table in ODX database is growing rapidly in terms of disk space

Hi community,I’ve a question about the ‘PK’ table that is created in the ODX when you enabled the ‘Handle primary key updates’ and ‘Handle primary key deletes’.I’ve noticed the ODX database (SQL Database) is growing rapidly in disk space after enable an incremental load schedule to reload data every 5 minutes. When I used the default SQL ‘Disk usage by top tables’ I noticed the PK tables are the biggest in terms of disk space.My PK table of the GL Entry table contains 4.5 billion rows! And is 95 GB. While my DATA table contains only 118 million records.When I query the PK table and filter the primay key in this table on 1 value. This value is saved 75  times in this table. For every odx_batch_number (odx_batchnumber 0 – 74). Is this normal? I think it is a bit strange that my PK tables are the biggest tables in the ODX in terms of disk space.Even when I run the storage management task. It doesn’t clean the PK table’s. It always contains the primary key for every odx batch load.The cust

2689
rory.smith
TimeXtender Xpert
erik.van.mastrigt
TimeXtender Xpert
erik.van.mastrigtTimeXtender Xpert
asked in Ingest
Loading Excel files from OneLake

Hi,I’m trying to load an Excel file from a OneLake. As OneLake is a rebranded version of Data Lake Gen2, my assumption is that it should be possible to use existing CData features to load data.I have a working setup where we use CData’s Excel provider (version 23.0.8585.0) to load an Excel sheet from a Data Lake Gen2 I explicitly configured the connection type as ADLS Gen2. Actually I was hoping that this configuration would work after changing the [Azure Storage Account] and [URI] to the OneLake parameters, but unfortunately that doesn’t work Error message:  Looking into the logs, I see that CData tries to connect to *.dfs.core.windows.net. However, the uri of OneLake is *.onelake.dfs.fabric.microsoft.com. Manually entering the abfss:// uri did not work here Is it correct that CData is not yet compatible with OneLake, even though techniques under the hood are similar? Documentation on https://cdn.cdata.com/help/RXJ/ado/default.htm does not mention it (yet).Did anyone manage to load da

43011
erik.van.mastrigt
TimeXtender Xpert
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
posted in Ingest
For "Add New Table" or the "Add New Table with Field Selection" option, the fields are either randomly arranged or aligned with the source database.

We have observed an inconsistency in the field order when adding a new table from the ODX to the DSA. Depending on whether we use the "Add New Table" or the "Add New Table with Field Selection" option, the fields are either randomly arranged or aligned with the source database.When we use “Add New Table” we notice that all fields are somewhat randomly arranged. When we use “Add New Table with Field Selection” and then check all the boxes the order is exactly as in the source database (as expected).  How come that there is a difference? Is this on purpose? Thanks (TimeXtender 6346.1)

963
kerry_bespoke
Contributor
K
Contributor
KarankadamContributor
asked in Prepare
filter on date column while exporting the data

I Have Invoice date column in my table, i want to export data of last 10 weeks, what are ways to do it in timextender

1034
Thomas Lind
Community Manager
O
Explorer
ofirbExplorer
asked in Ingest
Incorrect syntax near the keyword 'ORDER'

Hello,We’re getting the following error when executing a table in DSA.ODX object synchronization detects no changes, and our ODX source is synched as well.I’m guessing the ORDER is an order by… Any idea what causes it? Thanks

41812
daniel
TimeXtender Xpert
avanrijn
Contributor
avanrijnContributor
asked in Prepare
Going back in time to an earlier version of the MDW/SSL layer in TX version 21

Dear sir,In TX version 20 you can easily go back in time to an earlier version of your TX project.I am looking for going back in time to an earlier version of the MDW/SSL layer in TX version 21.I am running version TimeXtender 6143.1.Is this possible in the latest 6143.1 TX version ?Regards,Arthur

1913
P
Contributor
J
Contributor
jyothi.dosiContributor
asked in Ingest
Extract Data from D365 to datalake

Hi, Please can you suggest on the following : Export to Data Lake is depreciated by Microsoft in Oct 2024 this year. So, what is the best alternate solution to extract the data from ERP FO solution for reporting? How to extract data from Field Service & CE ERP solution? OData connector is not good option as it is very slow & I cannot build incremental load on this. 

1555
J
Contributor
K
Contributor
KarankadamContributor
asked in Prepare
Custom View Error

Below is error message when trying to create custom view, how can i sove it@Christian Hauggaard 

1066
K
Contributor

Badge winners

  • Certified Solutions Architect
    hay71has earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Himanshu Chhas earned the badge Certified Solutions Architect
  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
Show all badges
Terms and ConditionsCookie settings