Book a Demo

Author Topic: Reverse engineer Cassandra into EA  (Read 16923 times)

Dan Lavender

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Reverse engineer Cassandra into EA
« on: August 22, 2015, 06:16:09 am »
Has anyone reverse engineered a Cassandra NoSQL database into Enterprise Architect? If so, can you provide pointers?

Thx, Dan

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Reverse engineer Cassandra into EA
« Reply #1 on: August 22, 2015, 06:22:42 am »
I guess that is not possible. The RE supports only the listed DBs and none of them is a NoSQL. You're likely doomed to manually work that out.

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: Reverse engineer Cassandra into EA
« Reply #2 on: August 24, 2015, 11:23:48 pm »
As long as you can make an ODBC connection you should be able to reverse engineer any database to EA.
The supported databases are for forward engineering and using as storage for the models.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Reverse engineer Cassandra into EA
« Reply #3 on: August 25, 2015, 05:54:05 am »
Can you connect to a NoSQL over ODBC???

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: Reverse engineer Cassandra into EA
« Reply #4 on: August 25, 2015, 05:19:54 pm »
Quote
Can you connect to a NoSQL over ODBC???

q.
Some googling suggests you can: http://www.datastax.com/dev/blog/using-the-datastax-odbc-driver-for-apache-cassandra

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Reverse engineer Cassandra into EA
« Reply #5 on: August 25, 2015, 06:26:06 pm »
Interesting. The German Wikipedia still states that ODBC uses SQL as base language (I just looked). The English one doesn't.

q.

Dan Lavender

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Reverse engineer Cassandra into EA
« Reply #6 on: August 27, 2015, 12:27:00 am »
I followed the recommendation regarding using ODBC and downloaded the 32-Bit DataStax Windows 7 driver. I can connect successfully to the Cassandra instance from the Parallels/Win7/EA virtual machine to my Mac.

when I try to "Import DB schema from ODBC" command in Enterprise Architect 12.0.1215, EA pops up a status dialog, starts reading the system catalog and then crashes. No log messages are created.

I didn't find anything in the Forums.

Dan\