To homepage To homepage

General

General Questions about TimeXtender Data Sources

  • 20 Topics
  • 88 Replies

20 Topics

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).

2
Christian Hauggaard
Community Manager
5 days ago
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

3
R
Starter
15 days ago
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

0
G
Community Manager
19 days ago
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.

6
Christian Hauggaard
Community Manager
29 days ago
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. 

3
Thomas Lind
Community Manager
29 days ago
andri
Contributor
andriContributor
asked in General

BC Adapter - Merge extension tables option

In version 20.10.39 you sneaked in a new features in the BC Adapter data source: 17627: Business Central adapter - Merge extension tables option for SQL Server provider Added option to merge a table and its extension tables together as one table. This feature could be very useful but I can’t find any documentation on how it works and if there are any limits or considerations that need to be taken into account.Initial testing suggest that it works for some tables but maybe not for tables in extension modules?

10
Thomas Lind
Community Manager
1 month ago
P
Explorer
pontus.berglundExplorer
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!

6
AvanWijnen
Community Manager
1 month ago
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. 

11
Christian Hauggaard
Community Manager
1 month ago
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 ? 

2
bas.hopstaken
TimeXtender Xpert
1 month ago
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

5
E
Contributor
1 month ago
A
Starter
adijksmanStarter
asked in General

Cdata JSON connector in Business Unit different results

Dear community, Reach out to this community due to an issue with a JSON datasource connector.The situation:TimeXtender on premise (v20.10.40) using a Cdata ADO.net Provider for JSON 2021 (21.0.8011.0) in the Business Unit layer of the project. The connector uses a general account-password access for this datasource.User 1 logs on to the server TimeXtender is running on, does read data for this connector and got all the information expected.User 2 logs on to the server TimeXtender is running on, does read data and get just some information but not even related to this source. No error.Both users use the same connector with that general account to connect to this JSON datasource, but with different results.I asked for logfiles with verbosity = 3 of both users and attached are anonymized files. I am not sure how to interpret the differences in the logs.The log with the wrong results starts with a time out but playing around with this kind of setting does not change the outcome. Also some

3
A
Starter
1 month ago
bas.hopstaken
TimeXtender Xpert
bas.hopstakenTimeXtender Xpert
asked in General

Is there a (free/open) data source available to map companies to NACE Code?

Hi community,One of our customers want to report on NACE Code (see: https://nacev2.com/en). We are trying to find a (free/open) data source to map customers to the correct NACE Code.We do have the Dutch KVK/registration number and the EU VAT Number. Using one of these identifiers, we want to map the correct NACE Code.Does anyone have experience with this? 

4
bas.hopstaken
TimeXtender Xpert
2 months ago
K
Visitor
KashifVisitor
asked in General

Connecting To ETL Agile Using A JDBC Driver

Hi Support,Our client is using ETL Agile v20. They want to connect to Infor's datalake. Infor provide us with their Compass JDBC driver. Is it possible to import a JDBC driver into Jet to connect to their datalake? Are JDBC's supported with ETL Agile or will this be possible at all in a future release? Many thanks,Kashif

6
S
Community Manager
2 months ago
K
Contributor
KajEmergoContributor
asked in General

Excel Online connector 'Needs admin approval'

Hi all,When using the latest version of the CData Excel Online connector for extracting files from Sharepoint, we get a rather useless message after hitting the button ‘Authorize OAuth’. We are using the OAuth Grant Type ‘CODE’, meaning that we are only going to see the files that the account we are authenticating with can see on Sharepoint. The message we get after authenticating is like this: The message does not tell us what permissions we are missing, the account does have access to Sharepoint. However, it does not have access to the Graph Explorer. What kind of permissions do we need when authenticating this provider with a user account? Does it purely depend on the user account or does the App Registration require permissions as well? If so, which ones?

6
K
Contributor
2 months ago
M
Visitor
malknVisitor
asked in General

Microsoft Dataverse

Is there any information on when/if the Cdata connector for Microsoft Dataverse will be available in timextender

1
andri
Contributor
2 months ago
E
Participant
EvidaXremParticipant
asked in General

Setting up SQL Server Datasource using specific AD account (not integrated security) [Business Units]

I have a SQL Server Database that I have access to using my credentials, but need to set it up using a service account (AD Account). I have tested that this account has access to the SQL Server using the provided username/password in Power BI Desktop.Here are some screenshot of what I’m experiencing.Changed Authentication to AD Password Authentication:Changed the Encrypt connection option: It seems like the username is not transfered to the server…We are using TX 20.10.38.64TIA

4
Christian Hauggaard
Community Manager
2 months ago
ignacio
Explorer
ignacioExplorer
asked in General

Load CSV files from Azure Blob Storage

Hi everyone, I am adding a new data source to ODX, this connection has to load 6 cvs files from azure storage, could you help me to create the connection?Thanks Ignacio

2
ignacio
Explorer
2 months ago
michael.laenen
Starter
michael.laenenStarter
asked in General

Any possibility to read CDATA connection strings in clear text from repository?

Dear support,Historically, my customer is using several dozens of CData CSV or Excel file data sources.They have setup all those sources as Global Databases. Now they have to refactor file paths in all environments. Last Friday we were investigating if it was possible to retrieve the CDATA connection strings to those files by querying the repo but without success. For standard TX file data sources, it's possible to retrieve XML properties from GlobalDatabase tables but for CDATA (see picture 1), there is no obvious link to a CDataDataSourceID and even if we succeed to make this link, the connection string in the CDataDataSources table is hashed (see picture 2). Any possibility to decrypt this string or is the CData configuration stored somewhere else? Also nothing about CData connection string when we generate the project documentation =(

3
Christian Hauggaard
Community Manager
3 months ago
L
Starter
lpargiterStarter
asked in General

ApplicationIntent=ReadOnly

Is it possible to configure the default SQL connector Database Type "SQL Data Source" to use the Connection String property "ApplicationIntent=ReadOnly".   It does not appear to honor this setting as Timextender connects to the primary, not the read only replica.   We are confident in our Server side configuration as timextender is the only app we are having an issue with where an app does not connect to the read only replica when the connection property exists.  Is there another method for us to do this? Thanks, Luke

4
JTreadwell
Community Manager
2 years ago
E
Starter
eks_guasStarter
asked in General

cdata for dynamics 365 for operation not able to refresh.

I am working on a environment with TimExtender and Dynamics 365 for Operation.  First I must clear out ClientSecret and ClientAuthentication key before I can Authorize to d365.  After that i put in those keys and the session is started.  After a while the sessions is closed and I have to Authenticate myself all over again to be able to extract data form d365.   exept from logfiles> 2020-08-13T09.00.37.158+02:00 0 [Connection: 158] Executed connect: Error: AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. 2020-08-13T09.00.37.160+02:00 0 AADSTS7000215: Invalid client secret is provided.Trace ID: e4747361-a17c-448d-a5b9-b2d2fadbf800Correlation ID: 3ab329da-2059-4716-8a08-7f20e7835759Timestamp: 2020-08-13 07:00:37Z. ffo190j.xaat ffo190j.nna.C(ra , String )at ffo190j.nna.q(String , String , String , Boolean , Boolean , Boolean , BmB , BmB , BmB )at ffo190j.nnI

7
E
Starter
5 months ago

Badge winners

  • Certified Solutions Architect
    ParcifalVGhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    rasmusgadensgaardhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    JensFylkissonhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    f_keferhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    kerry_bespokehas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings