Author Topic: New tables into ea database (Read 4341 times)

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.

Paolo F Cantoni · « **Reply #1 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

Geert Bellekens · « **Reply #2 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

KP · « **Reply #3 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.

Paolo F Cantoni · « **Reply #4 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

topcatarg · « **Reply #5 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.

Sparx Systems Forum

News: