Add To Library Feature Request

  • Posts: 490
  • Karma: 2
  • Thank you received: 48

Add To Library Feature Request was created by bruce.gibbins

Hi

I would like to offer another feature suggestion which is based on our drive to make certain scenarios reusable or at least to allow the Object Library to store reusable components.

I believe that this facility could be greatly enhanced if it was possible to store a set of linked objects and not just a single object.

For example in the attached screenshot I am using a literal in an SQL Lookup to locate an associated Entity ID value from the database. If I select all of the linked objects and Add To Library, then only the SQL Lookup component is stored.

Ignoring the fact that SQL lookups are slow and we could (and do) do this through stored procedures down stream in the associated package it does sometimes make development easier if we could just do the lookup in the transformation when performance is not an issue.

Therefore, if we could just add the basic action object template into the transformation and then rework the input parameters accordingly, it would save having to reenter all of the inputs and outputs again.

Thanks for your consideration

10 months 4 weeks ago #21124
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 1225
  • Karma: 3
  • Thank you received: 160

Replied by Peter.Jonson on topic Add To Library Feature Request

Hi Bruce

Thank you for your feedback.
There is a batter option available already.
It is called sub-transformations.
They were created to be reusable and can be added to the objects library.

Peter Jonson
ETL Developer
10 months 4 weeks ago #21126
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 490
  • Karma: 2
  • Thank you received: 48

Replied by bruce.gibbins on topic Add To Library Feature Request

Thanks. I didn't notice these existed.

Appreciate it. They will come in very handy

Cheers
10 months 4 weeks ago #21132

Please Log in or Create an account to join the conversation.

  • Posts: 8458
  • Karma: 33
  • Thank you received: 567

Replied by admin on topic Add To Library Feature Request

Also not sure if you are aware that it is possible to create tabs within the transformation.
You may find it useful for complex transformation.

Mike
ETL Architect
10 months 4 weeks ago #21136
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 490
  • Karma: 2
  • Thank you received: 48

Replied by bruce.gibbins on topic Add To Library Feature Request

Thanks. Yes I use these quite a lot and it is what drove my feature request for a dedicated documentation tab in Packages and Transformations.
10 months 4 weeks ago #21137

Please Log in or Create an account to join the conversation.

  • Posts: 490
  • Karma: 2
  • Thank you received: 48

Replied by bruce.gibbins on topic Add To Library Feature Request

Thanks. Yes I use these quite a lot and it is what drove my feature requwstbforna dedicated documentation tab in Packages and Transformations.
10 months 4 weeks ago #21138

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies