Recently active topics

Hi, I am trying to conect to an endpoint using a dynamic query parameter from a simple SQL query: SELECT       [CODE_ID] as codeId  FROM [dsa].[Products]I use {codeId} as value in the query parameter. When deploying, I get the following error: Format of the initialization string does not conform to specification starting at index 0.  When I hard-code the codeId, it works. Using this query does not work. There are around 600 codeId's in the query. Even when i limit it to 2 id's, it gives me the same error. My API documentation does not mention anything about extra parameters. Also, the logs do not give me much more information, other than the error I mentioned. Anyone has experience with this error and has a possible solution? Kind regards,René 

Hi,i've got a couple of spreadsheets in a sharepoint folder that is would like to merge into one table in TX.I’m running TX V20.10.66.64i've setup a connection to the folder using provider TimeXtender Excel Data Source (16.4.20.0) and can see the files when i choose None for the aggragation option.When i select Files or Files & Sheets, no files are shown after running the sync or Transfer job.All files have just on sheet called 'Blad1’, the same amount of columns with identical names across the files. No tables are defined.What's misconfigured or going wrong?kind regards,Hans Zuijderwijk

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

In this article you will learn to make a Fabric Notebook accessible via the Fabric API, and run it through a Fabric Notebook package in TimeXtender Orchestration.In the Azure Portal, we need to create an App registration which we will use to access the Fabric Workspace. This is done under the Azure Portal -> Azure Active Directory -> App RegistrationGo to the Azure Portal Open App Registrations Select New Registrations Name your app and click Register The next window presents some key information that TimeXtender Orchestration will use to authenticate for later execution In the left panel, click Certificates & Secrets Then select New Client Secret Add an appropriate description and click Add at the bottom of the window Copy the secret value by clicking the Copy to Clipboard buttonAdd App Registration and user access to Fabric WorkspaceWith a Notebook already created under your Fabric Workspace you will need to grant at least Contributor access to the Workspace to a user that

When you have files in SharePoint, whether CSV, Excel, or similar, you can connect to them with our file-based Enhanced data sources.General connection settingsTo connect to SharePoint, you need to fill out the following options.SharePoint/OneDrive Client ID: Client ID of the service principal. SharePoint/OneDrive Client Secret: Client secret of the service principal. SharePoint/OneDrive Tenant ID: Tenant ID of the service principal. SharePoint/OneDrive Drive ID: Drive ID of the file location.To help locate this, I use Postman. I also use a collection. I attached it, but I can’t upload JSON files, so you will need to edit it to become a JSON file before you can import it.To import a collection, click the Import button in the upper left corner and locate the file.Once you have imported the collection to your workspace, you can set up the known variables.The SiteId and DriveId aren’t known at this time, so you can keep them empty for now.Regarding the Service Principal App. It is importa

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,I have a question regarding history-enabled tables and slowly changing dimensions (SCDs). In my case, I have a specific store that recently changed its store name. In the transaction table, I want to keep the old store name for all transactions prior to 01.01.2023.The best solution is probably to introduce a history table with a Slowly Changing Dimension on the store dimension, right?Currently, my table is incremental, but once a week we perform a full load back to 2021 (a large amount of data). According to the article I read, I should add an additional join similar to the one shown in the picture below. However, in my experience, adding such lookups often makes the execution significantly slower.What do you think? Do you have any suggestions for a better approach, or is this perhaps already the best solution?I’m also wondering whether it would help to convert the transaction table (the fact table) to a proper history table instead of keeping it as an incremental table? The dimensi

Hello, Three of my collegueas where developing in our dev enviroment. And when trying to save the project, we got the error:An error occurred while saving the project to the database.An item with the same key has already been added.Detailed error:An error occurred while saving the project to the database.Er is al een item met dezelfde sleutel toegevoegd.Details:Er is al een item met dezelfde sleutel toegevoegd.Module: mscorlibSystem.ArgumentExceptionbij System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)bij System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)bij TimeXtender.DataManager.ProjectPerspective.AddProjectPerspectiveItem(ProjectPerspectiveItemsRow itemRow)bij TimeXtender.DataManager.Project.InitProject(Int32 version, DsProject loadDsProject, DataSet adaptersDataSet, ProjectsRow projectRow)bij TimeXtender.DataManager.Project.LoadProject(DsProject _dsProject)bij TimeXtender.DataManager.Project.<>c__DisplayClass136_0.<Load

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 team I was recently working on a table where I added a hash field and configured it for incremental loading. However, the initial deployment failed because the table was missing the required column for the incremental process. When I attempted to redeploy to fix it, I hit a roadblock: a duplicate key error in dbo.DataFields with the value (ea41fe97-e408-4504-9164-239dfcdee390, 148, 99999999).  

Triggering Power Automate Workflows with TimeXtender OrchestrationTriggering Power Automate Workflows with TimeXtender OrchestrationIntegrating Power Automate workflows with TimeXtender Orchestration can streamline your data workflows by automating tasks across different platforms. This guide will provide you with the steps to trigger a Power Automate workflow from TimeXtender Orchestration using a PowerShell Package.Step-by-Step Guide1. Create a Power Automate Workflow with a HTTPS WebhookOpen Power Automate. Create a new workflow that starts with a "When a HTTP request is received" trigger. Save and note down the URL generated for the HTTP request.   2. Get the HTTPS Webhook URLYou will need this URL to trigger the workflow via PowerShell. For example, your URL might look similar to this:https://defaultxxxxxxxxxxxx.c7.environment.api.powerplatform.com:443/powerautomate/automations/direct/workflows/GUID/triggers/manual/paths/invoke?api-version=1&sp=%2Ftriggers%2Fmanual%2Frun&s

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

Schedule Groups are used to schedule automatic executions of objects.This tutorial covers the following topics:Creating Schedule Groups Schedule Triggers One Time Trigger Repeat Every Trigger Daily Trigger Weekly Trigger Monthly Trigger Custom Trigger Adding objects to the schedule Adding objects to schedule through the property grid Schedule OverviewCreating Schedule GroupsTo create a new Schedule Group:Right-click Orchestration > Schedule Groups Choose New > Schedule Group. An empty Schedule Group has three main areas:Objects currently in the schedule Schedule Trigger Objects available for schedule.Schedule TriggersA schedule trigger is a rule that determines when the Schedule Group will execute. For example, it could execute every 5 minutes between 9 am and 17 pm, or it could execute on the first Sunday every month at 9 am.When a schedule trigger executes, it executes all included objects at the same time on the environment (Development, Test, Production) defined in Execute on

Hi,We have been using Orchestration to schedule our TDI execution packages and Ingest tasks, and have tasks running every other hour. We now have a new requirement to be able to pause our schedule for service windows of a couple of hours every 2nd month. Does anyone know how to pause the schedule using Orchestration or some other tool?Any help is greatly appriciated. Best,Leo

How can I sort all my dimension in cube section and below ?

Hi, I have server, database, username and password for postgreSQL DB.with pgAdmin no issue it connects immediatelly. (no additional settings)In TX I tried CData ADO.NET Provider for PostreSQL 2022 (tried 2018 also, same result)Set SSL False - got error no encryptionSet SSL True - [500] System error: server certificate verification failed. Connection aborted. should I need any additional configuration, maybe different provider, any ideas? thanks in advance,Jakub

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 team, I am encountering a timeout issue when moving large tables. The problem seems to be originating from the cleanup stored procedure (clean sp), as smaller tables are processed without incident. Could you please look into this issue?  

I’m migrating a large SQL Dedicated Pool data warehouse to Fabric Lakehouse.I’ve run into Fabric’s workspace limit of a thousand items.What’s the best-practices workaround?

Hi TX Support, We're encountering a strange issue. We've setup an deliver instance of the REST API endpoint type. The model contains a dimension table. In the MDW layer this table contains 7844 records. Now when we pull the data from the REST endpoint we get 7844 as well, however the content is incorrect. Instead of the 7844 individual records we get 6974 records, 870 of those are duplicated and consequently 870 other records are missing. Example:DIM_Location TableLocation, Code, DW_Id Original MDW data LocationA, 123, 1LocationB, 345, 2LocationC, 678, 3 REST dataLocationA, 123, 1LocationB, 345, 2LocationB, 345, 2Missing Record in the REST dataLocationC, 678, 3Now I did tried everything I could think of in terms of troubleshooting. Everything is deployed, executed, refreshed and running. Going through the data I made an important observation. The set that is duplicated all are records that reside on the first page. They are then duplicated across the remaining pages. See the screenshot