#2006 Generate iTop MySQL/Mariadb generate non-enforced Foreign Keys with no constraints

[Ted Sheckler]

Hello,

We use a combination of 3rd party BI tools, we clone our iTop production schema into a Reporting instance. In addition in the Cron script we materialize all the OOTB itop Views, and create indices on anything with "id" in the name (above and beyond the OOTB PK id keys). We want to model a DW OLAP solution at some point, but who can find the time...

It works pretty well, but it would be great if we could generate non-enforced Foreign Keys with no constraints, using the itop Data Model schema (stored in middleware ORM side)

The benefit would be that 3rd party ER diagram reverse engineering tools (like SchemaSpy) could display a ERD, and secondly .. 3rd Party Reporting tools can generate a MetaData semantic layer (ie JasperReports Domain, Business Objects Universe, Apache SuperSet etc)

I know I can go one by one, add the keys, and using the naming convention could in theory generate a script ie functionalci.location_id > schema.location.id

Does anyone know if anyone wrote a itop ORM to DDL script (with relationships) .. or if Data Syncro maybe has a feature for FK .. ?

Thanks in advance

[Pierre Goiffon]

Hello,

Please use tickets for bugs reports and enhancement requests only. Your question is more about asking for assistance, so you should better create a new thread in the forum ("discussion" tab, "new topic" link)

I'm closing this ticket, but I'll be glad to contribute to the discussion in the forums !

[Ted Sheckler]

oops sorry, I made a mistake, don't post much

Thanks again for the response, I'll ask in the forums

On Fri, Nov 12, 2021 at 2:57 AM Pierre Goiffon pgoiffon@users.sourceforge.net wrote:

Hello,

Please use tickets for bugs reports and enhancement requests only. Your
question is more about asking for assistance, so you should better create a
new thread in the forum ("discussion" tab, "new topic" link)

I'm closing this ticket, but I'll be glad to contribute to the discussion
in the forums !

---

• [tickets:#2006] https://sourceforge.net/p/itop/tickets/2006/ Generate
  iTop MySQL/Mariadb generate non-enforced Foreign Keys with no constraints*

Status: new
3.0.1: 2.7.5
Labels: Foreign Keys SQL DDL reporting
Created: Thu Nov 11, 2021 08:27 PM UTC by Ted Sheckler
Last Updated: Thu Nov 11, 2021 08:27 PM UTC
Owner: nobody

Hello,

We use a combination of 3rd party BI tools, we clone our iTop production
schema into a Reporting instance. In addition in the Cron script we
materialize all the OOTB itop Views, and create indices on anything with
"id" in the name (above and beyond the OOTB PK id keys). We want to model a
DW OLAP solution at some point, but who can find the time...

It works pretty well, but it would be great if we could generate
non-enforced Foreign Keys with no constraints, using the itop Data Model
schema (stored in middleware ORM side)

The benefit would be that 3rd party ER diagram reverse engineering tools
(like SchemaSpy) could display a ERD, and secondly .. 3rd Party Reporting
tools can generate a MetaData semantic layer (ie JasperReports Domain,
Business Objects Universe, Apache SuperSet etc)

I know I can go one by one, add the keys, and using the naming convention
could in theory generate a script ie functionalci.location_id >
schema.location.id

Does anyone know if anyone wrote a itop ORM to DDL script (with
relationships) .. or if Data Syncro maybe has a feature for FK .. ?

Thanks in advance

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/itop/tickets/2006/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/