Skip to main content
To homepage To homepage

TimeXtender Desktop Q&A

Ask questions and find answers about TimeXtender Data Integration and TimeXtender Classic desktop applications

742 Topics
A
Visitor
andrew.charltonVisitor
asked in Ingest
Cdata connector for Zendesk

Hi I am trying to connect to Zendesk using the Cdata connector.I am getting the following error. Does anyone have this working. 'Initiate OAuth' does not have a  'REFRESH' option it only has NONE and GETANDREFRESHDetails:When using OAuth the 'Initiate OAuth' setting must be set to 'REFRESH'Module: timeXtenderSystem.Exceptionat TimeXtender.DataManager.DataSource_CData.CreateConnection()at TimeXtender.DataManager.DataSource_CData.TestConnection()at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)When using OAuth the 'Initiate OAuth' setting must be set to 'REFRESH'Module: timeXtenderTimeXtender.DataManager.ExceptionWrapperExceptionat TimeXtender.DataManager.ConnectingThread.HandleError()at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions)at TimeXtender.DataManager.ConnectingThread.ExecuteFastAction(String title, Action action, IWin32Window parentForm, CancelBehaviors cancelBehavior, ErrorBehaviors errorBehavi

221
thagin
Contributor
T
Visitor
tejasgVisitor
asked in Jobs & Executions
Continuous Integration in Discovery Hub

Hi, I need more information on how i can do continuous integration in discovery hub.

261
JTreadwell
Employee
R
Starter
r.brummansStarter
asked in Ingest
Cdata adapter - CSV File 10(GB)

We are trying to get a csv file of 10 gb into TimeXtender but it takes very long for TimeXtender to get this loaded and sometimes we are getting an error (system out of memory). Is there a solution or something else we can try to get big csv files into TimeXtener or can we change the CSV file to get it loaded into TimeXtender? We are now using the Cdata adapter and already used the multiple/single file adapter.   Thanks for the response!

383
JTreadwell
Employee
E
Starter
eric.vangemertStarter
asked in Jobs & Executions
Logging around setting "when transfer fails".

We started to use the configuration continue without data in case a transfer fails. The feature works fine, and we also see the message that one or more datasources fail. My question is, how can we easily see which datasources failed, and with what error message?  

616
Thomas Lind
Community Manager
H
Contributor
hgrContributor
asked in Jobs & Executions
Notification Execution Packages - Send mails using Google Mail

Hello, Which settings are needed in order to get Google Mail send success and failure emails in TimeXtender?  I tried it with  Servername: smtp.gmail.com Port: 25/465/587 Enable SSL/TLS: Checked Allow invalid certificates: Checked From Email: my.name@gmail.com User name: my.name@gmail.com Password: <my gmail password> To Email: another.email@gmail.com   I get different failure responses:  25: 5.7.0 Authentification required 465: Syntax error, command not recognized 587: 5.7.0 Authentification required   Without SSL/TLS I get: A secure connection is required for the smtp server or the client is not authentificated. Server response was: 5.7.0 Must issue a STARTTLS command first.   The responses are translated from german to english so please don't take them literally.   What are the corrected settings here? Is it something in my google account?  

1994
S
Explorer
P
Starter
per.schefferStarter
asked in Prepare
Clustered columnstore index

How do I tell TimeXtender to use a clustered columnstore index for my fact table in Azure Synapse?

772
P
Starter
A
Contributor
alain.thireContributor
asked in Prepare
Executing stored procedure

How can I execute a stored procedure once a load of a table is done. I know it should be possible. I just don't know where I should configure it  

861
JTreadwell
Employee
M
Starter
mcvStarter
asked in Jobs & Executions
Setting a flag when execution is done

Hi, We use TX as a part of our value chain of systems using data. We need to programatically be able to check if the execution is done, so the following jobs can start.I know TX can send an email when completed, but we really do not want to build the check on emails. Does anyone have a good idea on how to do this? Hope you can help. Best regards Michael Vaisgaard

362
JTreadwell
Employee
M
Starter
mcvStarter
asked in Prepare
Implementing SQL "CASE WHEN" Statement using native TX functionality

Hi, I have to do something like this in TX: If productno > 0 then 'Product A' else lookup in table productnames I cannot figure out how to do this in TX. Hope someone can help. Best regards Michael Vaisgaard

1232
M
Starter
H
Visitor
huub.thuijlsVisitor
asked in Jobs & Executions
Missing objects when executing a package after transfer and full managed deployment

I get the followinf error after transferring the latest version van OT to A environment and full managed deployment: Finished executing project 'RobidusDWH' Execution Package 'Laden ACC' Execution failed Start Time : 4/3/2020 7:16:52 AM End Time : 4/3/2020 7:25:01 AM on server: WIN6682 -Execute Execution Package Laden ACC 'Failed'                Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.                               Details:                               SQL Server: 'cf15a5af617c.tr6225.westeurope1-a.worker.database.windows.net,11009'                SQL Procedure: 'DMA_TX.usp_CrDM_DMA_TX_Feit_OpenstaandeTaken_HDA_HDA_V_DMA_Feit_OpenstaandeTaken'                SQL Line Number: 12                SQL Error Number: 208                               Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.                Module: .Net SqlClient Data Provider                System.Data

822
JTreadwell
Employee
T
Visitor
tejasgVisitor
asked in Jobs & Executions
How to schedule deployment from Development server to Integrated server

Hi, I am trying to find out how i can schedule deployment from development server to integration server at a particular time on everyday. So, whatever changes I am making in the development will be deployed automatically to integration server. Please let me know in case any one has idea regarding the same. For clarification please ask.

191
S
Contributor
B
Visitor
bunyamin.ozkilicVisitor
asked in Ingest
Extracting from Azure Service Bus

Hi, Is it possible to extract data from an Azure Service Bus into TX?

431
B
Visitor
A
Starter
alfred.kristinssonStarter
asked in Ingest
Google Cloud Platform

Hi, Is there any development on creating a connector to upload data to Google Storage Bucket or Google BigQuery?My bestAlfreð

915
Thomas Lind
Community Manager
Søren Sørensen
Contributor
Søren SørensenContributor
asked in Ingest
Synchronized data mapping from ODX Server

I'm currently migrating an Azure MI solution to ADLS Gen2 and Synapse Analytics. The migration includes remapping all DSA table ... instead of using an old ODX, DSA will now use an ADLS Gen2 on ODX Server. Mapping tables bring all data source fields across ... it would be nice to have the usual option to only synchronize existing fields as it's a lot of fields to delete when getting the entire data source table.

1152
Søren Sørensen
Contributor
E
Starter
erwin.dekreukStarter
asked in Deliver
Could not connect to the Tabular server.

Getting the following error while connect to AASCould not connect to the Tabular server.Could not load file or assembly 'Microsoft.AnalysisServices.Tabular, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.Is there a way to solve this?

722
M
Starter
R
Starter
r.rajStarter
asked in Jobs & Executions
TX- Oracle connector issue

The TX oracle connector drops and creates the complete table during export. Is there a way that we can control this behaviour and the table be not dropped ? This is because we need to move data from Staging Orcle to Main tables based on Triggers and if the table is dropped by TX then the trigger is of no use.

353
JTreadwell
Employee
S
Visitor
sai.mamidiVisitor
asked in Prepare
SQL 'Case'

How to write 'case' in Custom SQL, please let me know with example. Here is the situation (SQL query) that I need to perform on Date table & likes to update 'IND' column where DateValue is default column in Date table selectcase when GETDATE()<=DateValue then 'N' else 'Y' end as 'IND' ,* from <table_name> order by DateValue desc

481
JTreadwell
Employee
R
Starter
r.rajStarter
asked in Jobs & Executions
Pass project parameters at run time

Can you pass project variable values at run time via the command line? We need to trigger the package and pass on user defined variable values that has been used in the package creation. Like a date that a user can pass whenever he intends to run a package.

532
R
Starter
M
Explorer
mchinskyExplorer
asked in Jobs & Executions
Trying to Understand Incremental Performance

So based on what I'm reading about TX, it seems to me that even if only say 5 records changed on a source file, TX loads the entire source table into a Raw table (all 40 gigs of it) and then finds the 5 records.Is there a way to get it to just pull the 5 changed records into TX?  My incremental executions seem to take about 50% of the time of a full execution even though there is little to no data change.

552
E
Contributor
S
Explorer
Steven KoppenolExplorer
asked in Prepare
How to create a transformation that is different for each mapping going to the same table

Example scenario:Table DimProject has 2 mappings, each from a different source:Mapping 1 = SourceA.ProjectMapping 2 = SourceB.ProjectNow both systems will have the same project number with different meanings.My question is how do I make a transformation that returns 'A' + [project number] in mapping 1 and 'B' + [project number] in mapping 2.The solution needs be rely on explicitly meaningful conditions, no implicit conditions that drive people crazy trying to decipher what they are for somewhere in the future.Any ideas?

355
peter.jensen
TimeXtender Xpert
P
Visitor
Picanova BIVisitor
asked in Jobs & Executions
Transfer Error - Invalid column name - Incremental Execution MDW

Hello,one of several incremental tables won't execute. upon execution the transfer fails stating "invalid column name " & name of the incremental column.The problem occurred in Version 19.2.7.64 and is still present after an upgrade and redeployment to Version 19.11.7.64.What I tried so far. I tried to change the column from Incremntal_date to id.Redeployed the full table configuration.Upgraded to Version 19.11.7.64.Help is much appreciated. Best regardsPeter 

541
JTreadwell
Employee
D
Starter
dritzStarter
asked in Prepare
How can a parent-child hierarchy be historicized using parent DW_Ids?

How can a parent-child hierarchy be historicized using parent DW_Ids?

481
D
Starter
H
Contributor
hgrContributor
asked in Jobs & Executions
Manually reloading recent data

Just for anybody interested: I just found out that you just update the _I table to some older values, to reload all data greater than the value you set. Previously, I always reloaded the full table in these cases. This is not necessary and saves me some time from now on.

593
JTreadwell
Employee
S
Starter
stefan.timmermanStarter
asked in Ingest
csv filename changed after load

When I am using the Single text file and I am loading a csv file, TX replaces and removes the file to the Backup folder as specified. The filename before load:  E:\BAG\CoordinatenBAG2019.csv And the filename after loading:  E:\BAG\CoordinatenBAG2019__20191105_163142_ Now I have to rename the file every time i want to do a reload. How can I prevent this?  

192
S
Starter
H
Contributor
hgrContributor
asked in Jobs & Executions
Incremental Load not Delivering Data

Hello,I have the following setup for an incrementally loaded table:I would expect, that it loads all rows, with either an id greater than max id - 1000 or datum_post greater than max datum_post - one week.In fact, when I execute the query, it is not returning any rows. This is interesting, because removing the datum_post condition returns rows.Other tables with such a double condition (id + date) also work. I am wondering, whether it is necessary to have an index on datum_post in the source table? The queries can take quite a while on the datum_post field. The example query takes 2 minutes on the source database, but TimeXtender finishes after 30 seconds. TimeXtender says it is finished with "Success", but there are no rows.Also the following query yields results when querying the source database directly: I think this is the equivalent query to what TimeXtender should load.I am using Discovery Hub 19.6.7.64 and the source database is using (an old) mysql version: I am connecting with

801
H
Contributor

Badge winners

Show all badges
Terms and ConditionsCookie settings