Skip to main content
To homepage To homepage

General

General Questions about TimeXtender Data Sources

  • 59 Topics
  • 295 Replies
59 Topics
anders.e.jonsson
Contributor
anders.e.jonssonContributor
asked in General
Can you connect SQL Server database to ODX via a linked server?

Hi,A customer running version 6536.1 has provided us with a SQL Server database on a linked server (server L) as source, but we haven´t managed to connect to it so far.There is no problem running queries to that database on server L from management studio, when the query is run from the context of a database on server/instance where the linked server is added (server TX). This is a different windows server than the linked server.The appserver with the ODX-service is on yet another Windows server. The ODX database resides on server TX. Connecting to the ODX db and the TimeXtender MDW’s on server TX works fine.Is it possible to use a linked server as a source? If so, how should the server name(s) be specified in the connections settings in the portal?BRAnders

731
Christian Hauggaard
Community Manager
M
Starter
ManggaardStarter
asked in General
External Tables - Orchestration options

We are investigating the External Table feature to handle some special tables outside of TX, but still be able to utilize these for down-stream TX based processing.We would like to orchestrate the updates of these table from TimeXtender, but it seems like pre- and post execute scripts are not allowed on these tables.Can you confirm that pre- and post scripts are not available for external tables, alternatively provide a work-around to enable these. (It seems like a strange design choice to remove these hooks for this feature).Also, I find the schema option page grayed out on the table settings for an External table, would be nice to be able to put the generated views in some meaningful containers (not dbo).Thanks in advance.

513
M
Starter
J
Contributor
JogchumSiRContributor
asked in General
Using App Registration for Authentication on Azure SQL DB

I was looking into using a managed identity (App Registration) to authenticate TimeXtender with Azure SQL DB resources, but can't get it to work. I couldn't find much documentation on the support site either.I created a login on the database using T-SQL. I can also login with SSMS using the Azure Active Directory - Service Principal method: I'm trying by using the Active Directory Password Authentication method in the Connection Settings dialog. Testing the data source in TimeXtender gives an non-specific error:Service request failed: One or more errors occurred. (System.Exception)Details:Service request failed: One or more errors occurred. (System.Exception)Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C,T](WcfServerSettings serverSettings, Func`3 func) at TimeXtender.DataManager.EditDataSourceCommand.<Dialog_OnTestConnection>b__12_0() at TimeXtender.DataManager.ConnectingThread.ExecuteConnecti

8415
rory.smith
TimeXtender Xpert
N
Starter
nohikhStarter
asked in General
Undetermined SQL Server version during read of source schema

Hi TimeXtender,Suddenly, we're encountering an SQL Server error: "Undetermined SQL Server version during read of source schema."We're currently using TimeXtender version 20.10.14.64. My question is: Does TimeXtender support the following SQL Server version?Microsoft SQL Server 2022 (RTM-GDR) (KB5032968) - 16.0.1110.1 (X64) Nov 9 2023 22:31:58 Copyright (C) 2022 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)Thank you!Regards,Ismail

1355
N
Starter
L
Contributor
LorenzoContributor
asked in General
Properties Global database settings

Where can I find a description of the properties of the Global Database settings in general and in my case regarding a SQL server DB especially the “max rows to copy”. I have used 0 (hopefully then there is no limit but I have also seen that values are used).

2164
Thomas Lind
Community Manager
L
Contributor
LorenzoContributor
asked in General
Source table dependency

Hi,We use BU's and some sources are created in another TX project.How can I verify / check the dependency of a source in this case a SQL table?For example I have in the BU a SQL table (using global database) that is created in another TX project.How can I check which TX project has created this table?And also in general, how can I create a dependency list of a TX projects (dependency with other TX projects)?Is this stored in the repository? Regards,Lorenzo 

1665
Christian Hauggaard
Community Manager
A
Problem Solver
aftabpProblem Solver
asked in General
Change placement of RSD files

I have created a new disk om ny TX server to move RSD files out of C-disk.I understand that i have to change certain settings so that when i run TX it connects to the new disk and not C-disk.Where do i go to change settings for that?

952
A
Problem Solver
sierd.zuiderveld
Contributor
sierd.zuiderveldContributor
asked in General
Find Unused Fields

In TimeXtender 20.10.xx there was a button called “Find unused fields”. I have noticed that in version 6k there is no such button. Has it been moved or removed? Thx!

641
Christian Hauggaard
Community Manager
P
Contributor
pontus.berglundContributor
asked in General
Power BI dataset as data source

Hi,Has anyone used a Power BI dataset as a data source? I have tried using the CData SSAS connector but can not get it to work. Any advice would be appreciated.Best,//Pontus

1143
P
Contributor
A
Explorer
AndrewSExplorer
asked in General
Multiple CSV files with History (19.11.7.64)

Hi Everyone,---------BackgroundMy organization is trying to build a Supervisory Org tracking database. Our previous HRM system did this natively, and enough departments are tired of waiting for the new system quirks to be ironed out so I’m tasked with a work around. I can’t connect TX directly to the new system, but HR can download a csv that includes employee ID, Employee Name, Supervisor ID, Supervisor Name, Job Title, Work Location and various less critical fields.My plan then was to have an HR rep download the csv file once a week to a specific network folder, point TX at it with the Multiple Text File data source. I’d then use the DSA to perform some basic transformations and enable history on the DSA table. In theory this gives me a weekly update to an employee, tracking changes to key things like job title, supervisor, etc. We have a little over 1200 employees in the report, and 60-70k records a year shouldn’t be a problem. The initial ingest works well. TX reads the file, moves

1606
A
Explorer
M
Contributor
Michel van DrunenContributor
asked in General
Multiple XML files including filename

Hi I am using TimeXtender 20.10.37.64 incl. ODX server. I am trying to get some data from XML files with a wildcard which have the filename as a reference to another file. I am using the Cdata XML connector. I managed to get the data from both files in TimeXtender but can’t find a way to include the original file name to the table/query. Is there a standard option for this or maybe a workaround? Hope someone can help me.

1609
Thomas Lind
Community Manager
H
Explorer
htrimasExplorer
asked in General
Multiple Incremental selection fields

(Using Timextender 20.10.35.64)I have 2 date fields on a table. I want to load the row if one OR the other fields have changed in the data source. How do I do that?I tried doing this (see under)  but that caused duplicates because data had already been loaded (when only the loggedat field was the incremental field)  If I do this (see under) will it only load if both of the fields have changed? 

1745
Christian Hauggaard
Community Manager
M
Starter
MorganHeijdemannStarter
asked in General
Custom Data Provider alternative in latest TX version

Hi everybody,Our client uses a SOAP API from a supplier. While TX supports SOAP the extraction requires multiple steps and string manipulation. The complete process is:For each table in the list of tables: Call the first SOAP endpoint to retrieve the names of the fields in the table Call the second SOAP endpoint to retrieve a page of data for the table Split the data into individual rows by splitting the string on the ^ character Split the rows into individual colums by splitting the string on the | character Fetch until the number of rows returned is less than the page size Move to next table We created a custom data provider for the TX custom data connector. This works fine in TX 20.10, but is not supported in 6221, so we need to create an alternative. I’m aware that you can use RSD files for more advanced logic, but as far as I can see this doesn’t include an option to perform the string manipulation (splitting). For the time being, we’ve ported the logic to a Python script

1015
M
Starter
Bitmetric_Maarten
Contributor
Bitmetric_MaartenContributor
asked in General
Data format issues when loading CSV

Hi all,We are trying to load CSV files into the ODX using the CSV data source. However we are getting errors on fields it is trying to interpret as int (housenumber), but some are filled in as 12-18 and therefor failing. We have tried to use the override data type option, but to no avail. What can we do about this?Kind regards,Maarten

722
Bitmetric_Maarten
Contributor
kerry_bespoke
Contributor
kerry_bespokeContributor
asked in General
Historical Table Load Setup

Good DayI am setting up a new Data Source in TimeXtender. This dataset is very large and would like to eventually have this running as an incremental, but I have the task of importing the last 5 years of data first.I have tried to set this up with an Incremental Table setup in TX, but I keep getting a timeout setting. Iam wondering if I could set this table up as Simple for the historical load and then swap to Incremental but am worried my data would be cleared on changing the table type. Does anyone have any experience with loading in data with a similar scenario?Kerry 

2684
kerry_bespoke
Contributor
ignacio
Contributor
ignacioContributor
asked in General
TX customer data source

Hi FriendsI have used TX CDS to connect SQL Server because It was a best practice recommendation, but now I don’t know if CDS will be deprecated, What is the best connector for SQL Server? CDS will be deprecated? RegardsIgnacio

713
Thomas Lind
Community Manager
rogier.helmus
Problem Solver
rogier.helmusProblem Solver
asked in General
Overview connection tables and fields loaded with ODX server (documentation)

Hi all,I have a customer at which the data & analytics team has to report which data (tables & fields) is loaded into the data lake with ODX server for a certain source. This is because the source contains GDPR data and the data & analytics team has to prove to the legal team that they aren’t loading GDPR data into the data lake and further upstream.Unfortunately the TX documentation feature documents from the DSA and onward. The DSA documentation isn’t feasible for this request since we’re renaming fields and adding transformations. Is there a workaround to get this overview for a ODX server connection?Kind regards, RogierTimeXtender version: 20.10.39

691
Christian Hauggaard
Community Manager
R
Starter
remcoStarter
asked in General
Metadata TimeXtender Repository

I am looking for a way to find all tables in a perspective in a way I can analyse the differences between perspectives. In SQL in the metadata repository I would like to join ProjectPerspectives to the Datatables to find all Perspectives with certain tables, find which tables are not in a perspective and are therefor missed while loading data etc. I do not see an identifier thats Unique between the two so I am hoping one of you does :).  Thanks in advance, Remco

2063
R
Starter
G
Community Manager
Greg LennoxCommunity Manager
posted in General
Configuring a CSV data source stored in an Azure Data Lake Gen2 storage container

We were able to get this CSV file data source stored in an Azure Data Lake Gen2 storage container to work, but thought it may be useful to share, as we found that that the setup worked best when we were careful not to enter any other settings, but instead just entered those settings that were needed and described below. Source File: CSV.Storage Location:  Azure Data Lake Gen2 storage containerAuthentication Method: App Registration added to the storage container via a role assignment of "Storage Blob Data Contributor". Started by adding a new data source and chose the following:On the data source details page, entered the information for the 9 items outlined below, being careful not to enter information in any other boxes and just updating the necessary items. Item #1 will already be set to CSV based on the initial selection above, so that does not need to be updated. The following numbers correspond to the red boxes in the screenshot below.  Provider Name: This should be CSV based on

3220
G
Community Manager
S
Starter
SurendraStarter
asked in General
External table is not in the expected format

We have a project perspective called 'Reference' which contains ODX tables. When we are executing it through the execution package it is throwing an error  but when we try executing manually it is executing successfully.the file format which we are extracting is  XLSX. can you please help us to resolve this issue.

1396
Christian Hauggaard
Community Manager
S
Starter
Steini JonssonStarter
asked in General
Active MQ source

Is it possible to connect to ActiveMQ (https://activemq.apache.org) queue (as a source)?I use c# client app to fetch the data from the queue and was wondering if it is possible to use TimeXtender instead. 

503
Thomas Lind
Community Manager
P
Contributor
pontus.berglundContributor
asked in General
Connecting to multple databases on the same SQL Server

Hi,Is it possible to connect to several databases that are on the same SQL server with one data source connection?We have tried to connect to multiple databases on the same SQL Server using the provider “TimeXtender SQL Data Source 17.0.1.0”.We tried leaving the Database parameter blank, putting in *, and writing a comma-separated list of databases, but neither way works. Has anyone had any success doing this with this connector or another?We’re using version 6221.1.Thanks!

1026
AvanWijnen
Employee
L
Contributor
LorenzoContributor
asked in General
Read Excel decimal data with CDATA

I have an Excel sheet with percentages (11 decimals). The decimal sign is comma. See example below.Year    Period    CostPercentage2020    1    0,018001882020    2    0,016852519But when I read the data in TX then I see the below result:   I have tried to use the culture feature see below but no success. Find a screen dump belowWhy does TX / Cdata not read the data as is? The “,” is interpreted as a Thousand separator.Any help will be appreciated.When I have a file with a “.” (dot) as a decimal sign I convert the data to numeric precision 38,scale 11 and that works. 

37911
Christian Hauggaard
Community Manager
A
Starter
alexfeldStarter
asked in General
Using Exact with multiple divisions as a data source

Hello, I am currently trying to integrate Exact data using the TX Exact Online connector. I need to integrate data from a bunch of different divisions; I was wondering if the only way to do so was to individually add each division as a new data source or if there was another way ? 

1292
bas.hopstaken
TimeXtender Xpert
E
Contributor
ebayContributor
asked in General
invalid column name

Hello everyone,After the odx transfer task for API, when I click on the preview, I get the “invalid column name” error. This warning also occurs while executing in the data warehouse and stops execute.  What should I do? I wanted to use aliases but I have 575 columns.I tried to re-deploy the table with differential deployment disabled.  Version: 6143.1 My column name example is below: it is very long‘properties_parameter_WS10M_RANGE_202109’ ThanksBest Regards

4375
E
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