Book a Demo

Author Topic: Export Data Diagram or Class Diagram to csv or json  (Read 48463 times)

Typia

  • EA User
  • **
  • Posts: 88
  • Karma: +1/-0
    • View Profile
Export Data Diagram or Class Diagram to csv or json
« on: November 04, 2021, 02:53:33 am »
Hi guys,
I'm working on a project to validate data and structures on Apache Atlas.

We currently have physical data models and class diagrams in EA

I'd like to export models to a format that would be easy to integrate in Atlas.

When I try to export a class model or data model to csv I only have choice to export tables and their columns but no information about columns (type, etc ..)

When I try to export as XMI I know that all information is in the file but I'm struggling to understand the structure so I can convert it to a json entry file for Atlas.

I don't know if my issue is clear but I'd like to have an easy export solution with all structure information from a data model.

Many thanks.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #1 on: November 04, 2021, 09:46:24 am »
XMI is not easy because a model is complex. You can use the API to export your model in any form you like. Probably easier than to grasp XMI.

q.

Typia

  • EA User
  • **
  • Posts: 88
  • Karma: +1/-0
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #2 on: November 05, 2021, 12:15:21 am »
XMI is not easy because a model is complex. You can use the API to export your model in any form you like. Probably easier than to grasp XMI.

q.

Hi q,
thanks for your reply,
could you please point to a documentation regarding API ?

Thanks

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
The Sparx Team
[email protected]

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #4 on: November 05, 2021, 09:38:23 am »
Since you directly ask: have a look into my scripting book. I'd guess it's an easier way to learn the API than through Sparx help pages. Decide yourself.

q.

Typia

  • EA User
  • **
  • Posts: 88
  • Karma: +1/-0
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #5 on: November 24, 2021, 01:05:23 am »
Since you directly ask: have a look into my scripting book. I'd guess it's an easier way to learn the API than through Sparx help pages. Decide yourself.

q.

Hi q, thanks for your reply, where can I find your scripting book ? Didn't find it in your profile.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #6 on: November 24, 2021, 02:10:25 am »
It should be found via my signarture below my posts, though as it's just http some firewalls will not let it pass (heaven knows why). Otherwise you can find it at https://leanpub.com/ScriptingEA

q.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #7 on: November 24, 2021, 08:09:41 am »
You signature and the page it links to are served over http. They are the reason why I often get a mixed content warning when using the forum.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #8 on: November 24, 2021, 09:41:03 am »
Makes me wonder what would be the issue with http. Well, if that wouldn't be such a fuzz with obtaining a certificate I would have set up https. Though I don't see any reason why the content of my page would need encryption at all.

q.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #9 on: November 24, 2021, 10:43:51 am »
Makes me wonder what would be the issue with http. Well, if that wouldn't be such a fuzz with obtaining a certificate I would have set up https. Though I don't see any reason why the content of my page would need encryption at all.

q.
1. You are currently being penalized on google searches for being over http.
2. I don't know if google is indexing this forum, if it is, we are probably being penalized for linking to an image over http. If so it's reasonable that we would block images over http at some point in the future.
3. Someone could conceivably tamper with your instructions so that "you" are telling them to do something that will break everything. Alternatively, someone could tamper with the links in your page so that they go to a purchase of exactly the same thing where the money doesn't go to you.
4. In 2021 it just looks unprofessional to have http
5. A certificate from LetsEncrypt is free and in most circumstances easy to set up and self-renew.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #10 on: November 25, 2021, 01:00:58 am »
I might endeavor that during the winter. For the time being it seems that I'm not the only one using http here. And definitely I don't care much about Google liking my page or not.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #11 on: November 25, 2021, 03:10:26 am »
I think Chrome (at least on my machine) simply blocks anything not https.
I don't see your signature anymore.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #12 on: November 25, 2021, 06:11:32 am »
Yes, it's a browser issue. Chrome also blocks my site. Safari however shows it with no issue. Google, well....

q.

P.S. Found this. Unfortunately the author meant that a date is irrelevant. Judging from the source it's probably from mid 2020.
« Last Edit: November 25, 2021, 06:18:50 am by qwerty »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #13 on: November 26, 2021, 11:31:59 pm »
Look at that, q's signature has returned :)

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Export Data Diagram or Class Diagram to csv or json
« Reply #14 on: November 27, 2021, 10:09:58 am »
Yes. I bought a Thawte certificate. 35€ per year won't kill me. Though, still I don't see why crypting stuff that's put on a public billboard would be a necessity. But well, there are more crazy things out there currently...

q.