Unanswered questions

We are loading data from a SQL Server (onprem) to a Datalake (ingest instance). Data is stored as parquet, but TX is creating a huge parquet file for each table.  We are using ADF to ingest the data into the ingest instance.  Is there a way to load the data in such a way that when it gets into the Datalake the parquet can be divided in parts?  table_xxx_0001.parquet, table_xxx_0002.parquet, etc. (I know this is not the parquet format it is just an example).  Is this possible? We are having performance issues reading from parquet to AZURE SQL DB prepare instance.  We are using ADO.NET from ingest to prepare.

Hi,We are trying to access ODX execution history (backlog / queue / duration / errors) for log analytics purposes.We understand from documentation and release notes that the local ODX backlog (Backlog.sqlite) has been removed / moved in newer ODX versions, and that execution metadata is now handled differently.However, we are currently unable to locate where this information can be accessed programmatically.Additionally, in the TimeXtender Portal, we do not see the menu optionAdmin → Security / Permissions, so we are unable to: verify roles/permissions access or inspect the API for execution data Could you please help clarify: Where ODX execution history (status, start/end time, duration, errors) is stored in newer ODX versions Whether this data is accessible via: the TimeXtender Repository database, and if so, which tables/views are recommended the TimeXtender API, and what permissions are required Why Admin → Security / Permissions is not visible in our portal, and wha

Hi All,My current employer uses a DWH with a lot of views (with unions and so on), which leads to slow execution packages. I would like to enhance the performance (rebuilding the views is one thing). But i woud also like to enhance the performance with indexing. So i have setup up one of our Dimension tables as seen below:Is our SupernaturalKey (SNK) Are our PK'sWhat would you guys recommend? Which type of indexing for SNK (nonclustered, unique index, Columnstore Index, Clusttered ColumnStore Index)?Which type of index do you recommend for PK's (nonclustered, unique index, Columnstore Index, Clusttered ColumnStore Index) ? Which type of indexing SNK and PK in fact tables?  

Hi All,In TX 20.10.45.64 we would like to work with Work Items to prefent Project Locks. There is no option to Release the work item and make it green. I already tried:Deploy Execut Save and Reload the projectWe only have the option to update, edit or delete the workitem.  How do we release these items and make them green? 

Hi team,I have to set the incremental load best practice in my proyect, I need to know if the steps that I do are correct.First I set up the PK on ingest area.after that I set up the incremental Load Them in my Prepear area, I set on the tables incremental load. To finish I set add Incremental Selection Rule   Are thes steps correct? Is this the way to set incremental load?  Thanks for your support

Hi All,My current employer uses TimeXtender Desktop and two separate servers (dev/test + prod).The previous administrator installed the ODX server on the dev/test server. This causes issues when a datasource is modified, as it also affects the production environment.At my previous employer, we had an ODX server per environment: Dev ODX, Test ODX, and Prod ODX.My question is: what does the community recommend regarding having an ODX server on the dev/test environment?My ideas:Install the ODX Server on the production environment. Rename the VM.Thanks in advance for your help and input!Kind regards,Tim

Hi,I have a customer working with TimeXtender 7150.1 connected to Snowflake.I have a .csv data-source connected through the Ingest. The ingest settings have a number of header rows removed. But in the data received, I have Totaal-rows that I want to skip or filter out.The option to “filter rows” by right-clicking the data-source in the Ingest area is not available for this source: My next option would be to add a data selection rule to the table connected to the ingestion. But that has no effect: my result table has two rows (one from each .csv source) with Totaal.The above data selection rule seems not to be used. The only thing I can do to get it working, as far as I am aware, is to manually add a line of code, using the “Custom Code” option:But I was told / had learned that using the data selection rule, would automatically change the transformation script.I am not a fan of this solution, as it is not immediately clear to a new user (or to me in a year time) that I have changed the

Hi A customer of ours is noticing that the order in which TX is deploying and executing the datawarehouses they have causes empty tables. They are using TX Classic without an ODX, all sources are in Business Units. From the business units data flows to the DSA datawarehouse. From there it flows to the MDW datawarehouse and finally the data flows to the Delivery datawarehouse layer.When making changes to tables in the MDW layer that affect tables in the Delivery layer and then performing a deploy & execute you can clearly see that the affected tables in the Delivery layer are handled first followed by de MDW layer.This also happens in the scheduled executions causing empty tables and having to execute the Delivery layer by hand. Is there a way to change this order?

Hi we have a number of Orchestration Process Maps that have been published.Our client is wanting to start giving access to specific end users to check the status of and re - process certain maps.The client wants to only show the relevant process maps to these users. I cannot see a way to restrict the users access to view the maps, just which ones they can process.How can I enable this functionality for the client?