To homepage To homepage

- - Knowledge base overview
Product Updates
Training
Portal
For Partners
Legacy

Home
Search

Recently active topics

86 Topics

Recently active

Most views Most replies

Søren SørensenContributor

asked in Jobs & Executions

Intermittent execution issues

I’m regularly running into the “Cannot open server 'sql-instances-prod' requested by the login. Client with IP address '125.7.127.171' is not allowed to access the server.” error message, especially during overnight executions by the execution scheduler.But I can’t replicate the connection issue, i.e. it seems to be intermittent:Has anybody else encountered this issue and do you know what would be causing it / what the workaround might be?

1 day ago

timonStarter

asked in RSD File Customization

Pagination and recursive query

Hi,I have problem with pagination and recursive queryI have rest api endpoint:https://api.procountor.com/api/invoiceswhich returns invoice headers as"id": 6591273,"partnerId": 1208831,"type": "PURCHASE_INVOICE","status": "PAID","invoiceNumber": 16...etc.pagination works fine, I get every invoice headers (thousands) when pagination is set like this in RSD-file:<api:set attr="EnablePaging" value="true"/><api:set attr="pagenumberparam" value="page" /><api:set attr="pagesizeparam" value="size" /><api:set attr="pagesize" value="100" />But the actual details of invoice comes from endpoint like this:https://api.procountor.com/api/invoices/6591273So, I have to iterate thru one by one every invoice id that I get from https://api.procountor.com/api/invoices I have followed instructions from herehttps://legacysupport.timextender.com/hc/en-us/articles/360052383191-Creating-and-using-RSD-files-for-CData-providers#one-nested-calland I can query invoices successfully, but the

1 day ago

alain.thireContributor

asked in General

Installing 6221.1

I try to upgrade version 6221.1 for customer Dorel.eu . I have the license number. But it requires me to log onto one of your servers to get authorisation . I cannot do that with this user (not a dorel user). What should I do ?

2 days ago

danielTimeXtender Xpert

asked in ODX

RichTXEmployee

published in Tips, Tricks and Best Practices

Did You Know? Time is Money! What are the 5 features of TimeXtender that are "so money"? And what's with the name TimeXtender?Blog

Did You Know? Time is Money! What are the 5 features of TimeXtender that are "so money"? And what's with the name TimeXtender? They say time is money, and within the business world, time is a valuable resource. Just like money, wasting it can be just as costly, because time matters. In business, time is a critical factor in determining profitability, growth, and success. The longer it takes to produce a product or deliver a service, the higher the cost of production and the lower the profit margins. Similarly, if employees are not working efficiently or effectively, this can result in lost productivity and revenue, and thus, business growth, success, and bottom-line profitability. And in the data driven world of business, how you manage, understand, and utilize data has a direct impact on a business’s time and how it’s utilized. Therefore, to be successful in business, it is important to manage time effectively and efficiently. This means optimizing processes, minimizing wa

110

3 days ago

sguntupalliContributor

asked in Jobs & Executions

Schedular stopped working.

The scheduler stopped working in production. Yesterday I restarted but it still not running.How can I fix this issue?I have gone through the below document.Scheduled Execution issues - Did it not start, did it fail, or is my execution still running? – TimeXtender SupportOn my computer the recovery options were disabled.

3 days ago

william.sprangersExplorer

asked in ODX

ADO.NET Transfer consistently slow on incremental table with no new rows

Hi! I am experiencing an issue with ADO.NET transfer times on incrementally loaded tables where the ADO.NET transfer takes the same amount of time regardless of the amount of new rows coming into the table. A full load of the table containing about 45 million rows takes about 25 minutes, on the next incremental load the load time is still the same with ADO.NET taking up around 24 of these minutes. Our current data flow is as follows: SQL server → TimeXtender → Azure elastic pool (this is where all of our TimeXtender databases resides) Full load - 45 million rows Incremental load - 11 thousand new rows in the _R table The amount of new rows coming in to the table Has anyone experienced a similar issue? My best guess is that the problem resides in the azure elastic pool where the ado.net transfer is being throttled. Even if I have 0 rows in the _R table the ADO.NET transfer time is the same. Thank you!

3 days ago

Christian HauggaardCommunity Manager

published in TimeXtender Portal

TimeXtender API Endpoints

This article describes the various endpoints within the TimeXtender API and how to send requests using the TimeXtender Postman collection. To use the collection, download and install Postman, download the collection, open Postman and import the collection into Postman.PrerequisitesThe API Key needs to be setup in order to use the TimeXtender API endpoints.In Postman, select the Public - Jobs collection that has been imported in the left sidebar Select the Variables tab Enter the API key in the Current value for the variable apiKey (for more info on how to create an API key see API Key Management)Once entered, the apiKey variable is used for the entire collection, as the variable is referenced in the request headers for the various calls. Alternatively, the variable above can be entered manually within the request headers for the individual calls. For example, the {{apiKey}} variable for the job status request can be replaced with the actual API key.VariablesThe following variables are

4855

3 days ago

sguntupalliContributor

asked in General

How to move Project from Sandbox to production

SANDBOX Project developed using ODX server. Both environments Version: 20.10.36.64Please provide me with document to move environments.

4 days ago

JeroenSStarter

asked in REST APIs

POST request body REST connection

We have an API in which we have to pass a POST request with a request body to obtain the data. In Qlik Sense and Postman we have a basic connection established. However, there you can easily specify that the call should be a POST and you can also easily fetch the request body. In the CDATA REST connector in TX, we do not know where to fetch this request body in the connection. The demo endpoint we are trying to connect is:https://api.mews-demo.com/api/connector/v1/configuration/getwith the request body:{"ClientToken": "E0D439EE522F44368DC78E1BFB03710C-D24FB11DBE31D4621C4817E028D9E1D","AccessToken": "7059D2C25BF64EA681ACAB3A00B859CC-D91BFF2B1E3047A3E0DEC1D57BE1382","Client": "NameOfYourCompanyOrApplication"}Any help would be appreciated.

4 days ago

Niels JonkerContributor

asked in Jobs & Executions

Run transfer job only when ODX transfer task completed without errors

I want my transfer to MDW job to run only when my ODX transfer task has completed without any errors. What happens sometimes now is that for some reason there is an error in the extraction and some tables are empty, they then get pushed to the MDW and our reports break because the tables are empty. I see that you can use instance variables but I don’t see that option on my ODX. How can I set this up?

4 days ago

richardrayStarter

asked in Legacy & Upgrades

Use Project Variable as Fixed value for join

v20.10.36.64When setting up the relation between two tables, is there a way to use a project variable as the “Value” when the “Fixed Value” option is used?

4 days ago

nohikhStarter

asked in Data Warehouse

Extracting data from External-database

Hi TX Community!I get data from an external-database everyday.Since we have an aim of incremental-loading the data that we extract, we are doing some query-tables from the datasource to create a “incremental-load”-key.In that matter we are experiencing two issues:1- TX cannot read the date-formats that are extracted from the database. This is the format that we get out: Of course, we can right-click on the field and edit the datatype, but that we would have to do everytime we syncronize the datasource because everytime we syncronize the datasource all the date-fields are back to the “unknown”-format and therefore we would have to right-click on each field and edit the data-type. We’ve tried to use the “Data type overrides” but it doesnt seem that we can convert from an “unknown”-format. How can we solve this problem? As mentioned, the tables are query tables and therefore we would like to think that the date-formatting could be solved with a CAST or a CONVERT function. Any ideas?2- In

4 days ago

Thomas LindCommunity Manager

published in Data Warehouse

Previewing DataTutorial

TimeXtender’s Preview Table and Query Tool functionality provide developers with an easy way to review the contents of a table and perform quality control checks to confirm that the table is working properly as it is being developed. Previewing the results can be particularly helpful when coding transformations.Preview TableUse “Preview Table” to preview the contents of a table according to the following steps: Right-click on a table located in either a data warehouse or staging database, and then click Preview Table to open the following window and review the data in the table. Use the following options to adjust how the preview results are shown. In Select Top, type the number of rows to be fetched and displayed. Click Apply Top to apply the setting. Note that the “select top” setting is applied before any sorting of the data. In the Date format list, click the date format to use for dates. Click Apply Format to apply the settings. Once the format has been set it will be used fo

5 days ago

a.chikshinStarter

asked in RSD File Customization

Nested fields filtering in RSD file.

Hi,I have a problem with data catching from JSON file. The file looks like this:And I would like to get values from data field but only for en_US locale.I was trying to add filter in RSD file like below but it did not help:Can that type of filtering be used there?Greets, Aleksei

5 days ago

ebayContributor

asked in REST APIs

nested API pagination problem

Hello,To implement pagination in the API endpoint "https://domainname/api/v2/search/tickets?updated_since=2023-01-01T02:00:00Z&page{}", you need to provide the page parameter in a nested format. I prepared a custom RSD file specific to this API after reading the "Nested parameter" article. I have created a loop starting from 1 in the given code. However, I'm not able to see any data. I'm not receiving any errors during the transfer and synchronization processes. You can find the RSD file attached.I would appreciate in resolving this issue.Best Regards

5 days ago

alexfeldStarter

asked in Jobs & Executions

Advanced scheduling rules

Hello, I would like to set up a jobs on a hourly schedule for the first week of the month (and daily for the rest of the month). Is there a way to allow for more complex scheduling-rules for the Jobs ?

5 days ago

andrew.gebhardParticipant

asked in Semantic Models

Incorrect syntax for parameters on custom fields in Qlik semantic models

Hi team, TimeXtender allows adding parameters from a different table to a custom field in a semantic data model (Qlik). The resulting syntax/qlik script combination is always broken.When using adding a custom field parameter from a different table, TimeXtender fully qualifies the Qlik syntax regardless of the settings. The resulting syntax on the Qlik side will no longer match the syntax in the views created by TimeXtender:Qualified setting:Fully qualified setting: The resulting Qlik Script:"Sales_Targets":LOAD"KPI", "Target", "DIM_Boekdatum.DayName" AS "Test";SQL SELECT"KPI", "Target"FROM "Test"."dbo"."Test QVD_SLQV";But the view has the following syntax:CREATE VIEW [dbo].[Test QVD_SLQV]-- Copyright 2011 timeXtender a/s-- All rights reserved---- This code is made available exclusively as an integral part of-- timeXtender. You may not make any other use of it and-- you may not redistribute it without the written permission of-- timeXtender a/s.ASSELECT [KPI] AS [KPI] ,[Target] AS [Targ

5 days ago

Johnny YVisitor

asked in RSD File Customization

Using a nested REST API in combination with pagination (using the Graph API)

Hello everyone, I hope someone can help me with this.I am working on getting Azure AD Groups via the Graph API and then retrieving the members through a nested API call.I saw a post concerning a nested REST API call together with pagination in which one of the commenters (Gijs) had the exact same API which I am also using (commented by Gijs):https://support.timextender.com/rsd-file-customization-96/using-a-nested-rest-api-in-combination-with-paging-858However, the suggestion didn't work for my use-case as it only ‘expanded’ the nested values, but didn't paginate. I only got the members of the first 100 groups.I used the RSD-file from the commenter Gijs with the addition of two points:two additional rows to enable pagination; [memberout.userPrincipalName| allownull()] instead of [memberout.userPrincipalName] as I was getting a [500] error with this specific attribute.I've made them bold in the code down below.Would someone be able to give me some pointers to what I'm missing in the RSD

5 days ago

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

5 days ago

robert.kangasVisitor

asked in General

TimeXtender UI is intermittently slow

Hello there, we’ve been experiencing intermittent slowness in the TimeXtender UI within the past few weeks. Even doing simple things like right clicking on a execution package to view the logs, trying to see the status of an ODX transfer job, etc. will sometimes cause the UI to feel like it’s just not responding (no lotus status UI) for 30 seconds to minutes.This isn’t something that happens all the time and we haven't been able to nail down a root cause. Our VM where the UI is running is rarely over 30% CPU usage and we usually have over 80% memory free. Same goes for the VM that the ODX is running on. How do you even begin to troubleshoot this when the UI is slow to respond? The TimeXtender UI is on version 20.10.38.64. The TimeXtender ODX server is on version 20.10.37Thanks!

5 days ago

Niek.GuijtStarter

asked in REST APIs

Rest API rate limit

Hi,I'm currently connecting to a new api.https://ads-api.autotelex.com/swagger/index.html?urls.primaryName=Autotelex%20%7C%20Advertisement%20API%20V2%20(Beta)In my RSD file I call /api/v2/stock to get the ids for a stock, then I call /api/v2/stock/{adsStockId}/summary using the ids from the first call.The problem I run in to is that i can only make 300 calls per minute for the second call. Whenever I run into this limit my execute fails with the message: "Too many requests".Is there any way to limit or reduce the amount of calls I make per minute?Kind regards,Niek

5 days ago

remcoStarter

asked in General

Transfer TimeXtender to another Server

Dear Community, I have a few questions regarding transferring to another internal server and if you could help me with any of these questions help is appreciated.We have currently two servers running on SQL Server 2016, one server has the DEV and ACC environments and the second server has our PROD Environment (TimeXtender 20.10.39.64).The environments were installed by a supplier but their external employee left, so we want to try and install this on our own (with snapshots/backups in case something goes wrong).We want to try and move the DEV/ACC environment to a new server which has the same TimeXtender version but SQL Server 2019. For this move I have 3 questions:Can I just export and import the project from old server to my new server and load the data again into a new SQL database? How can I set up my environments in such a way that my DEV → ACC → PROD traject isn’t changed. I could not find those settings and had trouble finding them on the legacy page. As the DEV/ACC environments

5 days ago

Page 1 / 4

Badge winners

ParcifalVGhas earned the badge Certified Solutions Architect
rasmusgadensgaardhas earned the badge Certified Solutions Architect
JensFylkissonhas earned the badge Certified Solutions Architect
f_keferhas earned the badge Certified Solutions Architect
kerry_bespokehas earned the badge Certified Solutions Architect

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

SSO login

Username *

E-mail address *

Full Name

(Private)

Only you and moderators can see this information

TX Partner / Customer *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

SSO login

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.