Skip to main content
To homepage To homepage
SUBMITTED

Combine Ingest, Deliver and Prepare instances in same job

Related products:TimeXtender Data Integration
  • February 8, 2024
  • 1 reply
  • 33 views
Paul McLeod Bespoke Analytics
TimeXtender Xpert
Forum|alt.badge.img+2

Just completing a migration from TimeXtender Classic to TimeXtender Data Integration. One feature I was excited about was the new Jobs Feature! No longer.

Why can’t you combine Ingest Instance transfers and Prepare Instance Packages?

One real pain in TimeXtender Classic is the lack of synchronization between ODX loads and Execution packages resulting in messy scheduling requirements between the ODX and execution packages, never mind how you handle errors in and ODX load impacting a downstream Execution Package.

I was so excited, finally a great solution. A Job where I can schedule both in one area.

But no! You can either schedule Ingest Transfers, or Prepare Instance Package Executions, but not both in one job. Why? A real missed opportunity!

Please make this an enhancement to the Jobs sub system.

1 reply

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • rory.smith
  • TimeXtender Xpert
  • February 9, 2024

Hi @Paul McLeod Bespoke Analytics ,

there is actually a way to chain these together: you can set an Ingest instance source to be On-demand. Right-click data source > Edit data source > Advanced > tick the checkbox. This will result in any execution of a data area table that is mapped directly from the Ingest instance to trigger a reload of the respective Ingest instance source table(s). This is done without needing any explicit tasks defined in the Ingest Server.

Setting this does have some consequences:

  • It is no longer possible to only load Ingest instance → Prepare instance for a table without changing this on-demand setting (if you share an Ingest instance across environments that may be tricky). If you don't want to load a slow table from source each time you develop a data area table that is somewhat annoying
  • Right-clicking an Execution package for a Deliver instance and generating the dependent packages/tasks in Prepare and Ingest instance to reload that will not generate tasks in the Ingest instance for sources that are on-demand enabled

I agree the options are not as flexible as you would want and the interface is a obtuse, but at least it is possible right now.

    Terms and ConditionsAccessibility statement