Skip to main content
SUBMITTED

Reverse data Area .. refining

Related products:TimeXtender Data Integration
  • February 15, 2024
  • 3 replies
  • 31 views

Dirk Meert
Explorer

I love this feature, as it can also be used to quickly incorporate datawarehouses made when TimeXtender was not used yet.  

I gather that it was created because the Export/ Import feature from version 20.10  is no longer (or not yet?) available.


However, when taking a database, created with TimeXtender, it unfortunately simply also takes in the raw tables, Log and Message tables (as the gif in your article clearly shows). This means actually that you need to clean up a lot of “ingested” tables from the solution and remove all the system fields, like DWID, because the deploy just doesn’t work otherwise. 

If it wouldn’t take too much work, it would be great to have an option to  

  • Choose a Schema to import. If best practices are followed, then only the Valid schema should be enough.. and it would allow to import a Staging area only, or a Final area only
  • have a check box to remove any fields which would conflict .. and thus not scripting any of the system fields which TimeXtender will add again.

Until this is made, I’ll work on with a custom solution because I believe this feature offers the opportunity to refrain from re-inventing the wheel over and over again, but to inject template sets of tables and views to gain even more time.

3 replies

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

Hi @Dirk Meert ,

this feature has been around since at least 2016 - I keep forgetting what it is actually meant for and the documentation doesn't mention it at all (not even from the time :-) ). I think it is meant to be able to pull the structure of an existing data warehouse into TX as a skeleton so that you can work towards filling that structure with data. It is not meant as a way of importing/exporting as far as I know though I guess you could use it that way.

 


Dirk Meert
Explorer
  • Author
  • Explorer
  • February 16, 2024

Thank you for your feedback @rory.smith ,
I’m actually amazed that nobody else saw the potential there, as the feature was around since 2016. It’s now very visible in the data areas.  I hope more people take notice and request the “by schema” feature (and I hope the export feature will return soon).


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @Dirk Meert 

We have added the following feature to TimeXtender Data Integration

Although Integrate existing objects is slightly different than the reverse data warehouse functionality, this feature allows you to use objects from a non-TimeXtender data warehouse in TimeXtender. It also allows the selection of objects based on schema.