Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: topcatarg on September 15, 2009, 12:57:58 pm

Title: New tables into ea database
Post by: topcatarg on September 15, 2009, 12:57:58 pm

Hello. Is there a way to use the ea objects to get into new tables added to the ea database?? We are using it to store info about deploying documents artifacts (we don't share the database with develop).
So, do I have to manually connect to the database on my own or I can access it from the objects??
( I already found sqlquery, but we are looking for ways to store data into the tables).

Thanks.

Title: Re: New tables into ea database
Post by: Paolo F Cantoni on September 15, 2009, 01:01:39 pm

Hi,

Can you rephrase your question?

I, for one, am not clear what you are asking...

How many repositories are you talking about?  Are you trying to add new tables (as opposed to rows) into an EA repository?

Are you trying to link an EA repository with some other kind of repository?

HTH,
Paolo

Title: Re: New tables into ea database
Post by: Geert Bellekens on September 15, 2009, 03:48:48 pm

Sorry, I'm lost too.
I'd love to help If I only knew what you were talking about. :-/

Geert

Title: Re: New tables into ea database
Post by: KP on September 15, 2009, 04:02:43 pm

I think the OP has added extra tables to a DBMS repository or .EAP file, and is now hoping to be able to add data to the tables from within EA. Sounds "adventurous", and yes you would probably have to manually connect to the database from within an add-in to be able to write to the new tables. EA's custom SQL queries should be able to read from the tables, but can't write.

Title: Re: New tables into ea database
Post by: Paolo F Cantoni on September 15, 2009, 05:18:56 pm

Quote

I think the OP has added extra tables to a DBMS repository or .EAP file, and is now hoping to be able to add data to the tables from within EA. Sounds "adventurous", and yes you would probably have to manually connect to the database from within an add-in to be able to write to the new tables. EA's custom SQL queries should be able to read from the tables, but can't write.

If that's what he means, then yes it's all doable as Neil suggests...

If you're really adventurous you can do what we've done and have DB triggers do some of the work so that EA isn't aware that it's having "magic" performed behind its back...

Paolo

Title: Re: New tables into ea database
Post by: topcatarg on September 15, 2009, 10:09:18 pm

Sorry for the complicate way of my question.
Yes, I added extra tables to ea database and we where looking for a way to add data to them using the ea model objects (since we are building and add-in).
so, the best way is to get the data opening a connection on my side. Or is there a way to call a SP directly from ea???

Thanks guys.