Interoperability with other Platforms & Tools

Ask questions about external Platforms & Tools and how they fit into a TimeXtender context

  • 4 Topics
  • 13 Replies

4 Topics

G
Starter
greg.laymonStarter
asked in Interoperability with other Platforms & Tools

Seeking Best Approach to Add a Counter to a Table That Resets Based on Another Field

I have a table and I need to have a counter that restarts based on another field on the table. In my case I have a JournalBatchNumber field.  For each new batch, I need to generate a LineNumber restarting with 1 for each record of the same batch. Is this available in TX natively, or do I need to write a post processing script using rownumber ().  Thanks,Greg

2
M
Explorer
2 years ago
P
Starter
purnima.ozaStarter
asked in Interoperability with other Platforms & Tools

Can you use temp tables (sql - #tablename) in custom table insert SQL queries? This is for a custom insert table.

I am trying to replicate some code from SQL, and need to create a custom table insert... my SQL query uses a temp table #ELL.  When I try to deploy & execute, it does not understand the temp table.  Can temp tables be used here?  IE. #ELL.. I just need to have it hold some info that later in the query will populate the new custom table in TimeXtender.

4
Thomas Lind
Community Manager
2 years ago
G
Starter
greg.laymonStarter
asked in Interoperability with other Platforms & Tools

Using TX as a source to Dynamics 365

We are currently using TX to stage and merge multiple source systems to create a master list of items, customers, vendors, Open AR. Open AP, etc.  Currently, we are using the Data Export on the Semantic Layer to dump out entity data so that it can then be read in by D365 as delimited text files.  I am wondering if anybody knows if there is a way to direct connect to D365 so that TX serves as a source to a D365 system? Thanks, Greg  Laymon

1
J
Contributor
2 years ago
C
Starter
cwatkinsStarter
asked in Interoperability with other Platforms & Tools

Using TimeXtender to export to AWS

Good morning, We have a need to export a subset of data from our current Azure data warehouse to an AWS target. Does TimeXtender currently support AWS as a target? If so, could someone point me in the direction of some documentation on how to configure it? Thanks, Chuck

6
JTreadwell
Community Manager
10 months ago

Badge winners

  • Certified Solutions Architect
    Stefanhas earned the badge Certified Solutions Architect
  • Certified Solutions Architect
    Trine Stuhrhas earned the badge Certified Solutions Architect
  • Data Warehouse Expert
    Christian Hauggaardhas earned the badge Data Warehouse Expert
  • Innovator
    rvgfoxhas earned the badge Innovator
  • Certified Solutions Architect
    cbutcherhas earned the badge Certified Solutions Architect
Show all badges
Terms and ConditionsCookie settings