GSA 5.2.7. How to optimize businessobjects (emtpy columns, empty tables)

[Björn Schaefer]

Hi all

if there is a datasource with complex tables (like CRM Systems ...), than it is not really usefull, to create all businessobjects at once, while connecting the datasource.
when the datasource is connected, I may choose relevant tables to create businessobjects

But wich table is relevant ? ;-) First of all, I would like to find out, wich tables are empty (no data included) or full of data...

Is there any supporting function, to do something like this in one step? Most of DB datasources I connected in the past, do have plenty of empty tables and it would be very helpfull to use this Information (empty or not) for setting up a propper BO-model.

the same question follows one layer deeper...
If there are found tables worth to connect as businessobject, those may also have plenty of empty columns, so it would be usefull too, to eleminate those empty coumns...

thanks in advance!

 

[Joery Korobejnik]

Hi Björn,

We have a statistical AddIn feature source that can be used for this purpose. What version of GSA are you using, I can upload the relevant AddIn that you can add to the folder to enable this.



Kind regards,

Joery Korobejnik

 

[Björn Schaefer]

Hi Joery
since todays early morning, everythings is running in 5.2.8

 

[Joery Korobejnik]

Hi Björn,

Please download the attached .dll and place it in your AddIns directory. After restart of the application you should have a new custom Feature source available in the Add Feature Source Menu. When it is added to your project you will have multiple queries available to perform the counts (Business will give you all Business Collections and Source will give you all the tables from the feature source).



Kind Regards,

Joery Korobejnik

 

[Björn Schaefer]

hmm, maybe I'm blind a little bit ... may you tell me the name of the connector, that should appear here?



thanks a lot in advance...

 

[Joery Korobejnik]

Hi Björn,

Maybe you need to restart the application?



Kind regards,

Joery

 

[Björn Schaefer]

Sorry, my fault.... i copied the dll to GSA Server addins...