Recently active topics

This article describes how to add a CSV Endpoint to a Deliver instance. If you want to use data from the Deliver instance in an endpoint that is not natively supported by TimeXtender Data Integration, you can use the CSV endpoint to create files that can be read by almost everything under the sun. When you execute the endpoint, a file is created for each table in the model. Only regular fields are supported, not measures or custom fields.In the TimeXtender Portal navigate to Data Estate > Instances, click Add Instance> Add Deliver instance. Select CSV Endpoint from the Add endpoints list, then click Add an endpoint. Fill out the following fields in the form.In the Directory box, enter the path to the folder where the files should be placed In the File extension box, enter the file extension you want to use (usually "txt" or "csv") In the Encoding list, click on the encoding you want to use. In the Field names in first row, click No if you do not want the field names to be output

Hello,I have created a .csv endpoint based on a view in my MDW. I’m able to successfully execute the endpoint manually or through the execution package, where the .csv gets created as expected.However, I can’t seem to add the package to a job, and can’t get it to work through Exmon/Orchestration.In Exmon, my StocklistCSV package can be found. However, when I run it in Exmon, it doesn’t do anything and doesn’t show in the execution log. If I add the package in a process, it won’t run and time-out after 10 minutes.Do you have any idea how I can schedule to execution of the CSV endpoint so it creates the file based on a schedule?   

We have a client with a Rest Datasource that does not use URL parameters. Instead they use the post body to pass a series of filters and conditions.We are using this post body to implement Incremental loading from the datasource. It seems to be working correctly in so far as the rest source is definitely loading incrementally.However the Ingest instance does not seem to recognize the tables in the Gen 2 Storage as incremental.We have defined the incremental several times, deleted the entire folder in the Azure Gen2 storage. Still the same result.if we drag the table over to a data area the source in the Ingest instance is not flagged with an “i” indicating that it is incremental.Is this because we are passing the incremental variable through the post body and not as a query parameter?if this is the case is there a work around?The issue we are facing is that we cannot do any downstream incremental loads as TX complains that the source table in the ingets instance is not incremental. Not

When adding a conditional lookup in table A from table B an index is created in table B.This is expected behaviour when the Index generation setting is set to “Automatic”.However, if the lookup operator is set to “None”, no index is created in table B, eventhough index generation is set to automatic.Additionally, if a lookup is at first created with operator “Max” (or any other) an index is created, but if the operator is later changed to “None” the index is automatically removed. This seems like a bug. Is anyone else able to replicate this?I have tested this on version 7026.1

Hi all,I'm currently rebuilding an existing TimeXtender solution in another system and need to rebuild a large number of ETL pipelines.I'm wondering if there's an easy way to export the complete SQL logic for a single table, including things like:Joins Custom fields / calculated fields Transformation logic Lookup logic Any generated SQL behind the tableMy goal isn't to migrate the project itself, but rather to use the generated SQL as a reference.Is there a built-in way to export or generate the full SQL for an individual table, or is there another recommended approach for this type of migration?Have tried looking at the documentation export-option but I don’t think thats what Im looking for.Thanks!

Hello. This document has the ports which need to be opened. Configure your Firewall | Community It doesn't reference Fabric Lakehouse.. are you able to advise what we need to open for the ingest service to communicate to Fabric Lakehouse?Thanks Tim

Hello,Since about a month ago, I am not able to connect to Sharepoint Lists anymore. When I test the connection, I get the error message as seen in the image below. Authentication wise, I use Auth scheme AzureAD end the Sharepoint edition is Sharepoint Online. I do not use OAuth and I am able to login to the Sharepoint site with the account I use. Is anyone experiencing the same issue or does someone know how this can be solved? 

Hi all,Our TimeXtender is currently growing and growing, which is a good thing. However, I’m experiencing performance issues during TimeXtender execution and would appreciate guidance on both technical optimization and cost-efficient scaling.As my execution packages become unpredictable regarding execution times, i’m running into issues with PowerBI starting it’s refresh without TX being finished.TimeXtender Version: 7158.1 TX O&DQ Version: 26.1.0.23 ODX: Azure Data Lake Gen2 Execution VM: OS: Windows Server 2022 Datacenter Azure Edition Size: Standard D8s v5 (8 vCPUs, 32 GB RAM) Production Instance: SQL Server Storage Azure SQL Database: Tier: General Purpose (Provisioned) Compute: 2 vCores Storage: 65 GB I’m currently integrating data from about 15 sources, distributed across 5 ERP systems.I played around with execution package threads some time ago and i’m using 12 parallel threads for a while now. This package as a total task count of 540. During execution (mainly data load

Hi,We are consolidating our ingestion setup from one ingest instance per environment to a single shared ingest instance for both DEV and PRD environments.Current situation:ODX DEV → DSA_DEV → SSL_DEVODX PRD → DSA_PRD → SSL_PRDTarget situation: ↗ DSA_DEV → SSL_DEVODX PRD ↘ DSA_PRD → SSL_PRDThe DEV VM is able to communicate with the PRD VM, where the shared ODX instance is hosted.Could you please advise on the next steps required to implement this change?  

TimeXtender 20.10, colloquially known as "Classic", has been replaced by TimeXtender Classic as the bearer of the TimeXtender legacy back to the very first version from 2006.Before support for TimeXtender 20.10 ends in February 2027, we strongly recommend that you upgrade to either TimeXtender Classic or TimeXtender Data Integration. See Important information regarding TimeXtender 20.10, TimeXtender Data Integration, and TimeXtender Classic for more information.Differences between TimeXtender 20.10 and TimeXtender ClassicTimeXtender Classic has a focus on on-prem solutions based on Microsoft SQL databases, while its sibling TimeXtender Data Integration is built to take full advantage of cloud-based infrastructure such as Microsoft Fabric, Azure Data Lake, and Snowflake.Since TimeXtender Classic is designed to solve a more specific use case than TimeXtender 20.10, some 20.10 features are not available in Classic. We've also taken the opportunity to remove previously deprecated features

In this article you will learn to create an Azure PowerShell package in TimeXtender Orchestration and run itCreate Data ProviderOpen up TimeXtender Orchestration & Data Quality desktop client Right-click Data Providers, select New -> Data Provider Select a name for your Data Provider Fill in a description for your Data Provider Select the Systems in which your Data Provider should run Under Datasource Type, select Azure Connection Fill in the Tenant-Id, App-Id and the Client Secret Click SaveCreate packageRight-click Packages, select New -> Azure PowerShell Select a name for the Azure PowerShell package Select the recently created Data Provider, which should fill in the Subscription Name and Resource Group Name dropdowns Add the Azure PowerShell script you wish to run in the provided text field Click Save Finally, run the Azure PowerShell package

I have read through the guide(s) and posts, but still not able to solve the issue.The pagination info is on the top of the API response I am on page 2, reteriving only 1 record. I can reterieve max 100.This the API endpoint i am using: /api/result?pageNumber=2&pageSize=1{ "pagination": { "total": 29486, "pages": 14743, "page": 2, "pagesize": 1 }, "data": { "cases": [ { "index": 1, "id": 1, "subject": "Hidden", "description": "Hidden", "plaintext": "Hidden", "solution": "Hidden", "status": "Hidden", "priority": null, "impact": "Hidden"} ], "total": 1 }}I have overridden pagination - because not all endpoints are paginated.I dont want to reterieve all pages (which are 30 if i reterieve 1000 records per pageSize) before i know i can reterieve first 5This setting should be 500 recor

I have a large table with about 50 columns. There is column called projectNumber. This column, i am unable to override.This column is varchar. However in TX with Enhanced Drivers it shows Int32.I have overridden it to Text It even says so in Data type overrides on the DataSource I have even tried adding and removing it in Table builder  

I believe I have read the documentation, in case I missed something. My bad. Im trying to load csv files from the root of a S3 bucket. The 'test connection’ in the portal turns green but when trying to synchronize in timextender it tells me I have to enter a value for ‘path’.I have tried these so far: /.mybucketname/inbound/s3://mybucketname/inbound/But timextender keeps throwing errors saying the directory does not exist. I can succesfully connect to it and download the csv's via Python so Im quite sure the setup is correct.  Does anyone know what to fill in for ‘path’?

As you can see in this screenshot I’ve a custom field, defined several months ago, that uses fields from two tables: The model works perfectly, but in the current version I cannot edit and more CRITICAL for me, I cannot create a similar new one.I don’t know when this problem appears, but I’ve detect it today.What’s happen?

I have followed this guide to set-up an Incremental load on a table in BU:Incremental Loading in a Business Unit (BU) in TimeXtender Classic | CommunityHowever, during the deploy i get an error:Data source Incr LoadsValidation status: ValidMessage: OKStaging Database ODXValidation status: ValidMessage: OKTable: Incr_LoadValidation status: ValidMessage: OKIncremental LoadValidation status: ErrorMessage: Incremental load is not supported on this table.Details:Data source Incr Loads ...TimeXtender.DataManager.UserErrorExceptionIt says in the guide that: When the option is enabled and the table is deployed, TimeXtender performs the following:Initial Full Load: The system fully loads the table. Setting content of the _I Table: This table records the largest incremental field value from the given load I am attachig a video of where i get an error.What am i doing wrong?

Can I preserve my source field names when synchronizeing my fields?I dont want spaces and periods replaces by an underscore, my current workaround is to edit the fields manually when I use the tables in my prepare instance.