TimeXtender Community

Recent activity
Help others
Categories

rvgfoxProblem Solver

I’ve created a dynamic perspective based on an schema.If I try to create an execution package to execute all the tables in that perspective, it’s not possible.Is it a bug?

242

9 hours ago

DeanStarter

Interoperability with other Platforms & Tools

SSAS tabular TimeXtender/PowerBI

Hi,I am working with TimeXtender and have an SSAS tabular on-premise on a virtual machine as the endpoint. I want to publish my Power BI dashboard to the Power BI service. However, when I attempt to publish, I receive a message indicating that the connection to the data source is broken. How can I resolve this issue? We do not have Power BI Premium licenses, hence the use of SSAS.Looking forward to your response.Best regards,Dean

203

9 hours ago

Christian HauggaardCommunity Manager

Company Announcements

Support requirements

To be eligible for technical support in TimeXtender, please ensure your version in the five latest versions available for download.For more information on how to upgrade TimeXtender Data Integration, please see this article. For more information on how to upgrade TimeXtender 20.10, please see this article. If required, reach out to your partner, in order to get assistance in upgrading or reach out to support@timextender.com.

10 hours ago

AmrVisitor

Ingest

Invalid column count Excel sheet on storage account

Suddenly all the excel sheets are not loading anymore however some of them no one touched 6 months ago.the error is:Executing table excel_sheet:failed with error:Exception Type: System.ExceptionMessage: Invalid column count Stack Trace: at DataStorageEngine.DataLakeGen2.DataLakeGen2Transfer.<>c__DisplayClass41_5.<UploadData>b__14(DataTable dataTable, Partition partition) at DataStorageEngine.DataLakeGen2.DataLakeGen2Transfer.UploadData(ADLSGen2APIManager api, DataSourceModel dataSourceModel, DataLakeGen2ExecutionMethod executionMethod, Action`2 writeExecutionLog) at DataStorageEngine.DataLakeGen2.DataLakeGen2StorageEngine.<>c__DisplayClass35_2.<TransferDataAsync>b__7(DataLakeGen2ExecutionMethod executionMethod) at DataSourceEngine.Custom.CustomSourceEngine.InvokeDataSourceExecution(Action`1 action) at DataSourceEngine.Custom.CustomSourceEngine.RunExecu

10 hours ago

leo.noharetStarter

Prepare

Help with Primary Keys and Incremental Load in Table Inserts

Hi, I am facing an issue with duplicate records when using incremental load on a table that receives data via a table insert from another table in the same data area. The incremental load selection rule is based on DW_TimeStamp, and there are three PK in the target table.The issue is that the primary key does not seem to be enforced in the target table, as I am getting duplicate rows in the table. I tested this with another table where data is inserted through a table insert (but without incremental load), and I still see duplicate values for the PK fields and despite setting the table option to "Use instance setting (error)", no error is thrown when duplicates occur. I have tested this behavior in TDI 6935.1 and 6926.1, and the issue persists. My questions are: How do primary keys work with table inserts? Should they prevent duplicates, or do they not function as expected when using table inserts? Can incremental load be achieved using table inserts? If so, what are the necessary

495

13 hours ago

pkaustubhaParticipant

SAP

SAP HANA and SAP ECC with SQL/Oracle Database Connection with TimeXtender

Hi, Previously, we used SAP HANA (CDATA) connector to connect SAP HANA with TimeXtender. I understand from documentation that we can use Azure Data Factory - SAP Table and TimeXtender SAP Table Data Source for connecting with SAP HANA Data Sources. My question is withADF- SAP Table, does customer need to have ADF Subscription/Licenses. Also if they want deployment target as SQL Server On Premise. How can we user the same, TimeXtender SAP Table Data Source - Can we use this without Theobald Connector, if yes, how to use this with SQL server On Premise.Let me know the steps and example at the earliest.

18 hours ago

pkaustubhaParticipant

SAP

SAP Public Cloud - TimeXtender Connection

Hi,I was able to connect with SAP Public and Private Cloud, SAP C4C (SAP CRM), in the past using SAP Cloud for Customer (CDATA) connector which is no longer supported by TX. Please let me know on priority how we can connect to SAP Public and Private Cloud, C4C and other SAP Cloud Product using TDI. Please let me know with new options available what connector I need to use and how I can connect above mentioned data sources with TDI. I have a demo with a prospect. Need help on priority. Also share the steps and example, if possible

21 hours ago

thzmanParticipant

Ingest

SOAP request with encryption

Hi,I’m sorry for this somewhat lengthy post but I have a problem that I don’t really know how to solve and I’m just looking to see if anyone have run into the same issue, or maybe already solved it.We are going to fetch data from a time management system that have a SOAP API and all the information I find in the community refers to RSD files, that is not to be used anymore. I don’t know how I would solve the problem that I have even with an RSD file, but that’s somewhat beside the point here. 😊The issue is that we must take the request XML, encrypt the whole thing using AES, into a fingerprint that in turn will need to be inserted into the actual request that is then sent to the API.I have received some code in C# that does the following steps:Generates a timestamp and an MD5 hash of the request XML Generates the fingerprint XML using the timestamp and the newly created MD5 hash with the schema like in the attached picture fingerprint_schema Encrypts the fingerprint XML with AES, usi

288

1 day ago

Syed YousufContributor

Configure Resources

Use Snowflake for Prepare instance storageTutorial

Snowflake is a cloud-based data warehouse storage technology with automatic usage-based scaling of compute and storage resources. Additionally, Snowflake offers multi-cloud compatibility, allowing for greater flexibility in data management across different platforms.Released in TimeXtender Data Integration 6143.1 Snowflake Storage is available as part of the Standard, Premium or Enterprise PackageThe following functionality is currently supported when using Snowflake storage when using the TimeXtender Data Integration 6675.1 release or later:Ingest instance using Azure Data Lake Storage with SAS authentication Simple Mode tables Incremental Load Field Transformations Field Validations Conditional Look-ups History tables Supernatural Keys Custom Views Aggregate tables Table inserts Custom table insertsInstructions Create a Snowflake Database Get Snowflake Instance Details Configure Storage for Prepare Instance Configure SAS token for Ingest ADLS storage Connecting to Tabular, Table

21071

1 day ago

bjornContributor

Ingest

Avoid URL encoding in the Query

Hey, I use the REST connector to consume a CSV file. In my query parameters I got one for auth key. So when I try to load the file a get an error and the reason is that parameter get encoded (% → %25) . How can I avoid encoding in the query? /Bjørn A.

150

1 day ago

rvgfoxProblem Solver

Jobs & Executions

Dynamic Perspectives by schema

I’ve created a dynamic perspective based on an schema.If I try to create an execution package to execute all the tables in that perspective, it’s not possible.Is it a bug?

242

9 hours ago

DeanStarter

Interoperability with other Platforms & Tools

SSAS tabular TimeXtender/PowerBI

203

9 hours ago

AmrVisitor

Ingest

Invalid column count Excel sheet on storage account

10 hours ago

leo.noharetStarter

Prepare

Help with Primary Keys and Incremental Load in Table Inserts

495

13 hours ago

pkaustubhaParticipant

SAP

SAP HANA and SAP ECC with SQL/Oracle Database Connection with TimeXtender

18 hours ago

pkaustubhaParticipant

SAP

SAP Public Cloud - TimeXtender Connection

21 hours ago

bjornContributor

Ingest

Avoid URL encoding in the Query

150

1 day ago

r.miltenburgExplorer

Ingest

Schema already exists error when change data soruce connection

Hi,We've updatet our Data Integration version from 6766.1 to 6963.1. Which means we had to update our outdated providers. So we followed the steps mentioned in this post Change data source provider | Community (timextender.com).This results in an error when we try to full load changed data source. It keeps giving is the error: “The schema …. already exists on the SQL storage and cannot be used” Which actually means we can’t update our providers/ data sources. We have to create new ones en have to map all our tables in de odx. Anyone else facing this problem and have a solution for this?

435

1 day ago

aftabpProblem Solver

Prepare

Deploy running for over 20 minutes

This is a simple Deploy and its been running for almost 20 minutes.Whats wrong here?

1 day ago

nmoContributor

Ingest

REST: replace '' with NULL

I am trying to replace the CDATA Dynamics365 adapter with the TX REST connector (8.0.0) and I am having some issues where empty values from the API is interpreted as empty strings rather than NULL and as a result creates tables with incorrect datatypesHow do i set up a way to replace these empty strings with NULL values and keep the correct data types as wellI have tried with various combination of “Search and replace" on the endpoint as well as the individual nodes in the table builder without any luck.I also have the “Empty fields as null” option enabled.

183

1 day ago

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

Ingest

288 topics

Prepare

228 topics

Deliver

70 topics

Jobs & Executions

132 topics

TimeXtender Portal Q&A

Ask questions about the TimeXtender Portal

General

45 topics

Data Sources Q&A

Ask questions of about setting up data sources

General

58 topics

REST APIs

45 topics

RSD File Customization

25 topics

SAP

11 topics

Oracle

9 topics

ODBC

8 topics

General Q&A

Ask general questions

General

40 topics

Interoperability with other Platforms & Tools

12 topics

Legacy & Upgrades

67 topics

Security & Compliance

5 topics

Infrastructure & Networking

8 topics

XPilot

0 topics

Learn & Share

Share tips and best practices, show what you've created and inspire others

Success Stories

6 topics

Tips, Tricks and Best Practices

18 topics

TimeXtender Tuesdays

30 topics

Community Announcements

Everything you need to know about this community

Getting started in the community

8 topics

Company Announcements

18 topics

Exmon

General

16 topics

Community Statistics

1,660: Topics
5,632: Replies
1,059: Members

Awarded Badges widget

oscarclevehas earned the badge Innovator
leo.noharethas earned the badge Certified Solutions Architect
Bernarddbhas earned the badge Innovator
JeroenStahas earned the badge Certified Solutions Architect
nmohas earned the badge Ingest Expert

Show all badges

Leaderboard

Show full leaderboard

Ask Questions. Find Answers. Fast.

Download the latest version of TimeXtender Data Integration

Featured topics

The latest & greatest from the community

Community Statistics

Awarded Badges widget

Leaderboard

Need more help?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded