TimeXtender Desktop Q&A

How does "Table classification" in Table Settings affect a table ?Can't find any information in the user guide or google.For which cases "Dimension- /Fact Table (normal + large) are use full ?Many thanks for your help.Cheers Alex

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

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

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!

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?  

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?  

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

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  

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

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

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

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.

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

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

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.

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?

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.

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

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.

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.

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?

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 

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

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.

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?