To homepage To homepage

- - Knowledge base overview
Product Updates
Training
Portal
For Partners
TimeXtender Classic

Home
Community overview
TimeXtender Desktop Q&A
Prepare

Prepare

Ask questions about Prepare Instances in TimeXtender Data Integration

222 Topics
1,002 Replies

When you subscribe we will email you when there is a new topic in this category

222 Topics

Recently active

Most replies Most views Newest first

Stefan KauffeldStarter

asked in Prepare

Creating an row_number/Index/Sequence based on working days excluding holidays

Hi all, I am relatively new to SQL. Although with help and searching, I am making progress, I am not succeeding with the following question. Based on a date, I can easily set a filter in my reports to look ahead for x period of time. However, when a holiday comes into view, my report becomes blank. For this, I am looking for an index/row_number/sequence that skips the holiday dates. Can I set up a Custom Field for this within my BaseCalendar?

19610

8 months ago

Dirk MeertExplorer

asked in Prepare

Refresh of Instance does not show work from others, while Team development enabled

At a customer, we are developing in a team of 2 on TimeXtender 6536.1 .The Team development feature is switched on and, like in the 20.10.nn.mm version, I would expect the refresh button to bring out any deployments that my colleague makes and vice versa.But this doesn’t happen so. Only by closing an instance and re-opening it, do the deployed modifcations appear.Are we the only ones experiencing this? Or are there others?We know that you can use workitems to show others what you’re working on, to avoid working on the same objects, but would expect a refresh to also show new items, if one depends on the others work to proceed.

734

8 months ago

aftabpContributor

asked in Prepare

Converting to single database

I am trying to convert TX to single database and stuck here-- Set the source databaseUSE DVH_PROD_ODX; -- Source databaseDECLARE @SourceDatabase NVARCHAR(MAX) = 'DVH_PROD_ODX'; -- Source databaseDECLARE @SourceSchema NVARCHAR(MAX) = 'ODX_TZ'; -- Source schema in the source databaseDECLARE @TargetDatabase NVARCHAR(MAX) = 'DVH_PROD_MDW'; -- Target databaseDECLARE @TargetSchema NVARCHAR(MAX) = 'ODX_TZ'; -- Target schema in the target database-- Declare variables for table name and dynamic SQLDECLARE @TableName NVARCHAR(MAX);DECLARE @SQL NVARCHAR(MAX);-- Create a cursor to loop through tables in the source schemaSET @SQL = N'DECLARE table_cursor CURSOR FOR ' + N'SELECT t.TABLE_NAME ' + N'FROM INFORMATION_SCHEMA.TABLES t ' + N'WHERE t.TABLE_SCHEMA = ''' + @SourceSchema + '''' + N' AND EXISTS ( ' + N'SELECT 1 ' + N'FROM '+ @TargetDatabase + N'.INFORMATION_SCHEMA.TABLES t2 ' + N'WHERE t2.TABLE_NAME = t.TABLE_NAME ' + N'AND t2.TABLE_SCHEMA = ''' + @TargetSchema + '''' + N')';EXEC sp_executesql

251

8 months ago

sigsolContributor

asked in Prepare

TimeXtender Desktop on local machine

Hi!We have installed TimeXtender and ODX on an Azure VM (TimeXtender 6536.1). They are both running in ADF.I have installed TimeXtender Desktop locally on my own computer (outside of the VM) and I’m able to log in and open the instances. However, when I try to execute a table I get this error:-Execute Execution Package Execution Queue Default 'Failed' No DNS entries exist for host <nameofVM>. No such host is knownI am connected to the same network as the TimeXtender VM ('nameofVM') through a VPN connection.Is this setup not supported or am I missing some network configurations?

644

8 months ago

sigsolContributor

asked in Prepare

Download not newest TimeXtender Desktop

Hi!I want to download TimeXtender Desktop 6521.1 (not the newest one). Where do I find it?

942

8 months ago

KarankadamContributor

asked in Prepare

Error While Previewing Table

I've created view, and successfully deployed and executed, but while previewing the table it says timeout error, but that view I can open it in SSMS server, it takes 2 minutes to execute the view in server.what are steps or setting i should change to preview it in Timextender.

271

8 months ago

r.depagterContributor

asked in Prepare

Each date as individual row based on from and to dates

Hi, I am in the proces of migrating old Power BI managed data sources to our data warehouse in TimeXtender. However, in power query I use a function called List.Dates to create a row for each data between two dates. The data in this situation is sick days. Example below of what I need it to become: Sickdatefrom SickdateTo Sickday 1-1-2024 3-1-2024 1-1-2024 1-1-2024 3-1-2024 2-1-2024 In summary: I need to be able to add the Sickday column in TimeXtender just like I do in Power Query. I couldn't find anything online related to this subject. I am reading all thsis data from a CSV file by the way.

421

8 months ago

KCMTContributor

asked in Prepare

Incremental Load ODX and DSA with multiple Data sources set up - DSA load takes forever

TimeXtender Version 20.10.35.64I'm integrating 6 SQL databases/sources from the same ERP at the moment and want to set up incremental loading on my data source & DSA. I followed the basic steps but it seems like refreshing the incremental DSA tables takes way longer than a full load.The ODX datasources incremental LOAD tasks from all 6 data sources finish under 60 seconds, but the DSA load for e.g. AP_Products table now takes almost 15 minutes, for ± 40.000 rows, against 3 minutes for a full load. My Last modified DateTime column is ‘Date_Captured’ and is applied on the tables below. For all the 4 tables the PK's are set up. In the DSA I included column ‘Source’ in every table, which represents DW_SourceCode, to the PK of the tables to have an unique identifier per row. However, it looks like I'm doing something wrong or i’m missing a step, since it takes forever to refresh these DSA tables now

902

9 months ago

rvgfoxProblem Solver

asked in Prepare

Inner join in staging area

I have two tables Groups and GroupMembers. I need to get in GroupMember ONLY the members of the groups in the Groups table (INNER JOIN).The only way in TX without using views is: But it's not really a mistake.How can I do it?

791

9 months ago

rory.smithTimeXtender Xpert

asked in Prepare

New version of TimeXtender?

I have just downloaded the ODX Server and TimeXtender and it looks like TimeXtender has a new version: 6534.1 are there release notes coming for this?

571

9 months ago

KarankadamContributor

asked in Prepare

Fetching information from Tables

As shown in figure, Sales Ord Is My Base Table, and second table is Sales_ORD_LN_PROD_FAM,what i want to do is, Fetch PROD_FAM_NO,SALES_ORD_LN_NO column in to Sales Ord Table,Sales_Ord_No is same column in both Table,Is there any way to do it,

673

9 months ago

rvgfoxProblem Solver

asked in Prepare

Using very big tables

I have a very big table with millions of records.I’ve divided it in three mappings : aggregate, historical and current.If I need to do a full load only for the current mapping, what can I do it?

1013

9 months ago

KarankadamContributor

asked in Prepare

SQL Snippet Error

CREATE VIEW [Demo].[INVC_T] AS SELECT R.[ACCT_DT], R.[SPLIT_FROM_INVC_NO], R.[REMIT_TO_ADDR_NO], R.[USER_INVC_NO], R.[UPDT_PERS_NO], R.[UPDT_DT_TIME], R.[TOTALS_UPDT_DT_TIME], R.[SHIP_TO_ADDR_NO], R.[SEG_NO], R.[RECUR_INVC_NO], R.[PRINT_INVC_STATUS], R.[PMT_TERMS_CD], R.[JE_NO], R.[INVC_TYPE_CD], R.[INVC_STATUS_CD], R.[INVC_SRC_CD], R.[INVC_NO], R.[INVC_DUE_DT], CAST( ([INVC_DT]) >= DATEADD(week, -10, GETDATE()) AS datetime) AS [INVC_DT], R.[INSUR_AMT], R.[FRGHT_AMT], R.[CUST_TYPE_CD], R.[CURR_RATE], R.[CURR_CD], R.[CLOSE_DT], R.[BILL_TO_CUST_NO], R.[ACCT_YR], R.[ACCT_PER], R.[PMT_METH_CD], R.[CREDIT_CARD_FLAG], [DW_Id], [DW_Batch], [DW_SourceCode], [DW_TimeStamp], [DW_ODXBatchNumber], [DW_ODXBatchId] FROM [Demo].[INVC_R]

1688

9 months ago

RobertUParticipant

asked in Prepare

Error using data selection rule in DSA with data source ODX server

We are just started to use ODX server as a source for our countries that are migrated to Business Central in Azure. On our DEV environment i want to limit the data to only get entries after a certain date. Normally i would use a data selection rule on Posting Date Greater or Equal 2021-01-01When i want to do that on ODX server as a data source i get:Conversion failed when converting date and/or time from character string.I have tried every date notation i can think of but i always get this same error.Anyone any idea on how to filter dates from the ODX Server?

28433

9 months ago

KarankadamContributor

asked in Prepare

filter on date column while exporting the data

I Have Invoice date column in my table, i want to export data of last 10 weeks, what are ways to do it in timextender

914

9 months ago

avanrijnContributor

asked in Prepare

Going back in time to an earlier version of the MDW/SSL layer in TX version 21

Dear sir,In TX version 20 you can easily go back in time to an earlier version of your TX project.I am looking for going back in time to an earlier version of the MDW/SSL layer in TX version 21.I am running version TimeXtender 6143.1.Is this possible in the latest 6143.1 TX version ?Regards,Arthur

1713

9 months ago

KarankadamContributor

asked in Prepare

Custom View Error

Below is error message when trying to create custom view, how can i sove it@Christian Hauggaard

956

9 months ago

boyclaesenContributor

asked in Prepare

TimeXtender Execution stopped running

Hello, For two weeks my clients Power Bi report was refreshed daily without issues. Last week this changed after the TimeXtender Execution server stopped running. I ran the TimeXtender ODX Server Configuration on the desktop and started the TimeXtender execution server again. The next days the execution jobs where triggered again but I would like to know why TimeXtender Execution stopped running in the first place. How could this have happened?

611

10 months ago

PhantipaVisitor

asked in Prepare

Where can I find a full example both json response data file and RSD file for "Enum and page method" ? Or anyone can give me an example?

I’ve read the artical Enum and page method but we still have a question how the json response and the RSD file should be.It would be great if anyone provide a full example (json response data and the RSD) so that we can fully test.Thanks for advance!

811

10 months ago

vw-victaContributor

asked in Prepare

Data Movement Azure Data Factory - (ForEach Loop) Slow performance

Hello,we're using Timextender with ADF for the data movement between our Data Lake storage and SQL Database. Running the execute from TimeXtender of rerun it within ADF the performance is poor (slow!).Our setup at the moment, regarding to the specs within the topic "Create a Demo Template Project TX SaaS”. We wanted to start basic and then tweak the settings for better performance. Executing the first SQL DatabaseService tier: General Purpose Compute tier: Serverless Hardware: Standard (Gen5), Min/Max vCores 10 and 30GB Min/Max Memory Auto-pause delay: 1 hourIntegration Runtime - type AzureComputer Size: smallWe tried using a different Computer Size on the IR and also changed the SQL DB Tier for more DTU. No performance improvement after changing.Looking at one of the jobs we are transferring 2048 rows from our Data Lake to our Azure SQL.The Queue is taking most of the time. We did some research on the support page of TimeXtender (No topics) and also at the Microsoft community. Ther

7993

11 months ago

rory.smithTimeXtender Xpert

asked in Prepare

Should multiple SQL statements be possible in the query tool?

In v20 and before you can define multiple statements in a query tool window. This can be handy when doing comparisons or dealing with wide tables. v20 statement 1 v20 statement 2 In v21 the second statement is simply ignored for SQL DWH instances and results in an error in Snowflake:v21 SQLv21 Snowflake ; separating statements Was this taken out of v21 or should this actually work like in v20?

CarloCDOStarter

Hi all,I recently created a bunch of SQL logins in TimeXtender to use in our Database Roles we set. After I did that I found out I made a mistake and I removed those SQL logins from the database. However, when I try to edit a database role and try to Add a login, I still see the SQL logins I removed.To make sure there is nog caching or something involved I waited a few days before checking if they were still there.Does someone have a solution to remove those logins from the list? I don't want to create new names for my SQL logins just to avoid having the same name as the previous one. Although, if that is the only option I am willing to accept that as well. Kind regards,Carlo

662

11 months ago

sierd.zuiderveldContributor

asked in Prepare

DW_SourceCode as natural key

Hi all, We ran into an issue with history settings in combination with the DW_SourceCode. We need the DW_SourceCode in our primary key as there is overlap in the sources and this ensures uniqueness. In the history settings we cannot choose the DW_SourceCode to be the natural key: Without this, history does seem to work, but when we enable Create new record when a deleted record reappears in the source We obtain the error Error during Data Processing for Table: Maintenance.Verkoopinfo at: MaintenanceThe column name 'DW_SourceCode' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.I've looked into the stored procedure that produces this error and this snippet produces the error: -- History: handle deleted records IN

17610

11 months ago

ebayContributor

asked in Prepare

Is it possible to extract created date for a CSV file?

HelloI need the creation date and time (createdAt) of a CSV file within the MDW table as a column. How can I access this information?Best Regards

2599

11 months ago

r.miltenburgStarter

asked in Prepare

Issue with running scheduled jobs

We have created several jobs on our ODX and several jobs on our DataWarehouse. The ODX jobs are running correctly based on schedule, but the Datawarehouse jobs never run since there is a schedule.We've also deployed and saved our project, so that should not be the problem.

764

11 months ago

Page 3 / 9

Badge winners

avanrijnhas earned the badge Ingest Expert
danielhas earned the badge Deliver Expert
p.ruijterhas earned the badge Jobs & Executions Expert
lstegmeierhas earned the badge Certified Solutions Architect
Bennyhas 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 E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

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.