Skip to main content
To homepage To homepage

Recently active topics

51 Topics
Christian Hauggaard
Community Manager
Christian HauggaardCommunity Manager
published in Deliver
CSV EndpointTutorial

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 as t

7124
Thomas Lind
Community Manager
Emiel van Schaik
Visitor
Emiel van SchaikVisitor
asked in Ingest
Does anyone have experience with Adnamics as a datasource?

As title suggests, I wonder if anyone in this community has experience with ingesting TX with the data source Adnamics and their API. Thanks in advance!

242
rory.smith
TimeXtender Xpert
B
Contributor
bjornContributor
asked in Ingest
Avoid URL encoding in the Query

Hey, I use the REST connector to consume a CSV file. In my query parameters I got one for auth key. So when I try to load the file a get an error and the reason is that parameter get encoded (% → %25) . How can I avoid encoding in the query? /Bjørn A.

463
Christian Hauggaard
Community Manager
A
Problem Solver
aftabpProblem Solver
asked in Prepare
Deploy running for over 20 minutes

This is a simple Deploy and its been running for almost 20 minutes.Whats wrong here?

284
Christian Hauggaard
Community Manager
Thomas Lind
Community Manager
Thomas LindCommunity Manager
published in Data Sources
Use OAuth 2.0 client authentication to connect to Graph API with the TimeXtender REST data sourceTutorial

It is possible to use OAuth 2.0 as the authentication method for the TimeXtender REST data source. One API that uses this is the Graph API. Content Content Prerequisites Application setup Access Token URL Scope Initial setup Set up OAuth Authentication Main Endpoints Users Groups Teams Set up pagination Dynamic endpoints Users messages Team members Prerequisites Using the postman collection explained in this guide Use Postman is a good start as the method is pretty much similar. What we will do is the application method aka Client Authentication. Application setup As mentioned above you need to use Application rights for client authentication, so the app you want to use for this must have the correct rights. The Delegated rights are easier to set as they mainly do not require Admin consent, that is not the case for most Application rights, so get these rights authenticated before starting. I got one app where I got all the application rights added If you want access to groups and users

6827
peter.jensen
TimeXtender Xpert
L
Starter
leo.noharetStarter
asked in Prepare
Help with Primary Keys and Incremental Load in Table Inserts

Hi, I am facing an issue with duplicate records when using incremental load on a table that receives data via a table insert from another table in the same data area. The incremental load selection rule is based on DW_TimeStamp, and there are three PK in the target table. The issue is that the primary key does not seem to be enforced in the target table, as I am getting duplicate rows in the table. I tested this with another table where data is inserted through a table insert (but without incremental load), and I still see duplicate values for the PK fields and despite setting the table option to "Use instance setting (error)", no error is thrown when duplicates occur. I have tested this behavior in TDI 6935.1 and 6926.1, and the issue persists. My questions are: How do primary keys work with table inserts? Should they prevent duplicates, or do they not function as expected when using table inserts? Can incremental load be achieved using table inserts? If so, what are the necessary con

727
L
Starter
Christian Hauggaard
Community Manager
Christian HauggaardCommunity Manager
published in Data Sources
Extract Data from SharePoint Lists

Prerequisites Create an Azure App Registration The App Registration should use the Microsoft Graph API with the following permissions: Finding the List ID Use Postman to find the Site ID. Use the Site ID to find the List ID. You can find these by using Postman and by looking at the Graph API collection Graph Fork . You can use the app to connect to this and locate the SharePoint folder under Application. In there you have two requests, https://graph.microsoft.com/v1.0/sites and https://graph.microsoft.com/v1.0/sites/{{SiteID}}/lists . Use sites to find the site ID and use the SiteID to find the List ID. You can also find the ListID by navigating to the SharePoint list and then clicking List settings and then copying the ListID from the URL Use the TimeXtender REST data source connection Connection Settings Use the following Base URL (where {{SiteID}} is the Site ID found in Postman): https://graph.microsoft.com/v1.0/sites/{{SiteID}}/lists Endpoints Create the endpoint using the followi

932
Christian Hauggaard
Community Manager
T
Participant
truttafiskerParticipant
asked in General
Copy Semantic layer or Copy tables/relations from exsisting semantic layer to new ?

is it possible, as the title says .. to Copy and entire semantic layer to a new semantic layer, or copy the exsisting tables with relations from 1 semantic layer to a new one ?

91
Christian Hauggaard
Community Manager
T
Visitor
Tim TurnerVisitor
asked in Deliver
Creating Sematic models PBI

Hello, I am trying to setup an endpoint to PowerBI Premium in version 20 (20.10.58) The connection is setup as below, and it tests OK (See pic). When I Deploy I get the error: Failed to save modifications to the server. Error returned: 'Either the database with the ID of 'TXFinance1' does not exist in the server with the ID of 'host002_datasets-231', or the user does not have permissions to access the object. The Semantic model is created fine in PowerBI, but nothing inside of it. Is there a setting I am missing? The stange thing is that it appears to work for a colleague in the same workspace using the same app credentials, but not on my machine Many thanks, Tim

283
rory.smith
TimeXtender Xpert
G
Visitor
gislihbVisitor
asked in ODBC
Connect to MongoDB

I'm trying to connect to MongoDB and load data into Timextender I have a ODBC driver setup, and test connection works. In Timextender I have ODBC Generic Data setup, and test connection works and to Synchronize Data Source works as well. But when I try to execute the data transfer from MongoDB into Timextender then I get an error.

1084
peter.jensen
TimeXtender Xpert
A
Starter
AmrStarter
asked in Ingest
Invalid column count Excel sheet on storage account

Suddenly all the excel sheets are not loading anymore however some of them no one touched 6 months ago. the error is: Executing table excel_sheet:failed with error:Exception Type: System.ExceptionMessage: Invalid column count Stack Trace: at DataStorageEngine.DataLakeGen2.DataLakeGen2Transfer.<>c__DisplayClass41_5.<UploadData>b__14(DataTable dataTable, Partition partition) at DataStorageEngine.DataLakeGen2.DataLakeGen2Transfer.UploadData(ADLSGen2APIManager api, DataSourceModel dataSourceModel, DataLakeGen2ExecutionMethod executionMethod, Action`2 writeExecutionLog) at DataStorageEngine.DataLakeGen2.DataLakeGen2StorageEngine.<>c__DisplayClass35_2.<TransferDataAsync>b__7(DataLakeGen2ExecutionMethod executionMethod) at DataSourceEngine.Custom.CustomSourceEngine.InvokeDataSourceExecution(Action`1 action) at DataSourceEngine.Custom.CustomSourceEngine.RunExecution[M](DataExecutionDestination dataExecutionMethod, Action`1 action) at DataStorageEngine.DataLakeGen2.DataLakeGen2StorageEngine.<>c

528
Thomas Lind
Community Manager
G
Community Manager
Greg LennoxCommunity Manager
published in Data Sources
Adding a SharePoint site as a data source

This article clarifies two different methods of adding a SharePoint site as a data source in the TimeXtender Portal. Method 1: Basic Authentication This method specifies a user account that does not have MFA two factor authentication enabled and has been granted access to the SharePoint site. The configuration in the TimeXtender Portal for the SharePoint data source is as follows: Provider: Microsoft SharePoint Auth Scheme: Basic Share Point Edition: SharePoint Online URL: <SharePoint Site URL> i.e. https://contoso.sharepoint.com/sites/PBI User: <username> of a user that has been granted access to the site. Password: <password> for the specified user. Method 2: OAuth This method uses an Azure App Registration and OAuth to connect to the specified SharePoint site. In the TimeXtender Portal, create a new data source and set the provider to be “Microsoft SharePoint”. Auth Scheme: “SharePointOAuth”. Share Point Edition: SharePoint Online URL: <SharePoint Site URL> i.e. https://contoso.shar

10789
R
Participant
Thomas Lind
Community Manager
Thomas LindCommunity Manager
published in Data Sources
TimeXtender Excel data sourceTutorial

You can use this provider to connect to Excel files. It can connect to multiple files at once and merge them based on specific options such as files, sheets or both. There also is options making it possible to connect to setups that is not straight forward, using table definitions, culture settings and more. Configuration manual Connection settings Path Include sub-folders Metadata URI Location Local file or folder Azure Blob Storage settings AWS S3 Bucket settings SharePoint or OneDrive settings Google Cloud Storage settings SFTP settings Excel settings Set first non-empty row as column names Table definitions Only use defined tables Aggregation Included sheets Infer datatypes Number of rows to infer data types Culture Number decimal separator Date formats Misc behavior Test connection Configuration manual The following settings can be used with the TimeXtender Excel data source connector. Connection settings These settings relate to the connection to where the Excel file is located.

71113
J
Starter
R
Participant
r.miltenburgParticipant
asked in Ingest
Schema already exists error when change data soruce connection

Hi, We've updatet our Data Integration version from 6766.1 to 6963.1. Which means we had to update our outdated providers. So we followed the steps mentioned in this post Change data source provider | Community (timextender.com). This results in an error when we try to full load changed data source. It keeps giving is the error: “The schema …. already exists on the SQL storage and cannot be used” Which actually means we can’t update our providers/ data sources. We have to create new ones en have to map all our tables in de odx. Anyone else facing this problem and have a solution for this?

646
R
Participant
J
Contributor
juriaan.hensbroekContributor
asked in REST APIs
TX Rest Dynamic value Endpoint query

I'm using dynamic values function in the TX REST connector 9.1.0.0. I use id's from another endpoint to loop through in my second endpoint path. This works well when I use “From Endpoint Table” but now I want to add a filter to only get the id's with a flag “hasresponse=true”. I've read the page but I still get an error with my Endpoint query. “No such table” the error message says. I've tried several things like adding a schema. But all with the same response. Is there something wrong with my syntax? Error:

453
Thomas Lind
Community Manager
T
Participant
thzmanParticipant
asked in Ingest
SOAP request with encryption

​Hi, I’m sorry for this somewhat lengthy post but I have a problem that I don’t really know how to solve and I’m just looking to see if anyone have run into the same issue, or maybe already solved it. We are going to fetch data from a time management system that have a SOAP API and all the information I find in the community refers to RSD files, that is not to be used anymore. I don’t know how I would solve the problem that I have even with an RSD file, but that’s somewhat beside the point here. 😊 The issue is that we must take the request XML, encrypt the whole thing using AES, into a fingerprint that in turn will need to be inserted into the actual request that is then sent to the API. I have received some code in C# that does the following steps: Generates a timestamp and an MD5 hash of the request XML Generates the fingerprint XML using the timestamp and the newly created MD5 hash with the schema like in the attached picture fingerprint_schema Encrypts the fingerprint XML with AES

3711
T
Participant
Christian Hauggaard
Community Manager
Christian HauggaardCommunity Manager
published in Company Announcements
Support requirements

To be eligible for technical support in TimeXtender, please ensure your version is one of the five latest versions available for download. For more information on how to upgrade TimeXtender Data Integration, please see this article. For more information on how to upgrade TimeXtender 20.10, please see this article. If required, reach out to your partner, in order to get assistance in upgrading or reach out to support@timextender.com.

264
Christian Hauggaard
Community Manager
Dean
Starter
DeanStarter
asked in Interoperability with other Platforms & Tools
SSAS tabular TimeXtender/PowerBI

Hi, I am working with TimeXtender and have an SSAS tabular on-premise on a virtual machine as the endpoint. I want to publish my Power BI dashboard to the Power BI service. However, when I attempt to publish, I receive a message indicating that the connection to the data source is broken. How can I resolve this issue? We do not have Power BI Premium licenses, hence the use of SSAS. Looking forward to your response. Best regards, Dean

314
rory.smith
TimeXtender Xpert
P
Participant
pkaustubhaParticipant
asked in SAP
SAP HANA and SAP ECC with SQL/Oracle Database Connection with TimeXtender

Hi, Previously, we used SAP HANA (CDATA) connector to connect SAP HANA with TimeXtender. I understand from documentation that we can use Azure Data Factory - SAP Table and TimeXtender SAP Table Data Source for connecting with SAP HANA Data Sources. My question is with ADF- SAP Table, does customer need to have ADF Subscription/Licenses. Also if they want deployment target as SQL Server On Premise. How can we user the same, TimeXtender SAP Table Data Source - Can we use this without Theobald Connector, if yes, how to use this with SQL server On Premise. Let me know the steps and example at the earliest.

131
rory.smith
TimeXtender Xpert
P
Participant
pkaustubhaParticipant
asked in SAP
SAP Public Cloud - TimeXtender Connection

Hi, I was able to connect with SAP Public and Private Cloud, SAP C4C (SAP CRM), in the past using SAP Cloud for Customer (CDATA) connector which is no longer supported by TX. Please let me know on priority how we can connect to SAP Public and Private Cloud, C4C and other SAP Cloud Product using TDI. Please let me know with new options available what connector I need to use and how I can connect above mentioned data sources with TDI. I have a demo with a prospect. Need help on priority. Also share the steps and example, if possible

100
P
Participant
S
Contributor
Syed YousufContributor
published in Configure Resources
Use Snowflake for Prepare instance storageTutorial

Snowflake is a cloud-based data warehouse storage technology with automatic usage-based scaling of compute and storage resources. Additionally, Snowflake offers multi-cloud compatibility, allowing for greater flexibility in data management across different platforms. Released in TimeXtender Data Integration 6143.1 Snowflake Storage is available as part of the Standard, Premium or Enterprise Package The following functionality is currently supported when using Snowflake storage when using the TimeXtender Data Integration 6675.1 release or later: Ingest instance using Azure Data Lake Storage with SAS authentication Simple Mode tables Incremental Load Field Transformations Field Validations Conditional Look-ups History tables Supernatural Keys Custom Views Aggregate tables Table inserts Custom table inserts Instructions Create a Snowflake Database Get Snowflake Instance Details Configure Storage for Prepare Instance Configure SAS token for Ingest ADLS storage Connecting to Tabular, Tablea

21131
Alexander Khorunzhiy
Starter
Thomas Hjermitslev
Community Manager
Thomas HjermitslevCommunity Manager
Data source providers (Excel) r. 2025-04-24

Today, we’ve released an updated data source provider for Excel. Note: Today’s release contains the TDI version only. 20.10 BU and 20.10 ODX versions will follow. Excel Version: 23.2.0.0 (TDI) Added ‘_ResourceURI’ column as an available metadata column. This column is automatically populated with the filename of the Excel file for that row. Added default file types. Changed some file management behavior to avoid locking files. Fixed a bug related to aggregation of files and sheets and infer data types.

460
Thomas Hjermitslev
Community Manager
P
Explorer
Pieter-JanExplorer
asked in Legacy & Upgrades
upgrade to 20.10.63

Hi, I'’ m upgrading from 20.10.52 to 20.10.63 and are waiting for a long time (over a hour) message “please wait while the application is preparing for first use” and after a while a message “installer not reponding “ with a retry or cancel. Is this normal behaviour?

388
P
Explorer
N
Contributor
nmoContributor
asked in Ingest
REST: replace '' with NULL

I am trying to replace the CDATA Dynamics365 adapter with the TX REST connector (8.0.0) and I am having some issues where empty values from the API is interpreted as empty strings rather than NULL and as a result creates tables with incorrect datatypes How do i set up a way to replace these empty strings with NULL values and keep the correct data types as well I have tried with various combination of “Search and replace" on the endpoint as well as the individual nodes in the table builder without any luck. I also have the “Empty fields as null” option enabled.

213
Thomas Lind
Community Manager
J
Starter
jasperpStarter
asked in REST APIs
Passing a dynamic value as an additional column next to the output of the call it is used in?

I am using a Power BI endpoint (https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history) where I need datasetIds to get the refreshes of that dataset. I am using the TimeXtender REST data provider, in which I loop over a list of dataset ids using a dynamic value. The problem is that in the output of the Get Refresh History endpoint the dataset Id is not included. Therefore, my question is: Is it possible to pass a dynamic value used in a call as an additional column next to the output of the call? I don't see any option for this in the portal. If I were to extract the data using Power BI, I would do the call for every row in a table containing the required dataset Ids and expand the resulting column. This way, the original table column containing the dataset Ids will always be related to the dataset refreshes. Can I do the same using TimeXtender?

694
M
Starter

Most helpful members this week

Badge winners

  • Innovator
    oscarclevehas earned the badge Innovator
  • Certified Solutions Architect
    leo.noharethas earned the badge Certified Solutions Architect
  • Innovator
    Bernarddbhas earned the badge Innovator
  • Certified Solutions Architect
    JeroenStahas earned the badge Certified Solutions Architect
  • Ingest Expert
    nmohas earned the badge Ingest Expert
Show all badges

Popular tags

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings