Eclipse Community Forums: EMF » Ad-hoc ODBC to Ecore model

Help

Home

Home » Modeling » EMF » Ad-hoc ODBC to Ecore model

Show: Today's Messages :: Show Polls :: Message Navigator

Ad-hoc ODBC to Ecore model [message #532838]

Tue, 11 May 2010 11:01

Christophe Bouhier

Messages: 937
Registered: July 2009

Senior Member

Hi,

I am looking for a solution, whereby a connection to a DB, would be a
data source, which can be easily mapped to ECore and merged into an
existing model.

My toughts would be to

1. Create the connection using Eclipse JDT Connectivity.
2. Somehow map the retrieved objects into a dynamic ECore. (Note sure
how yet).
3. Use m2m (QVTO) to transform to my target model.
4. Use EMF Compare/Merge to load my target model.

Preferably this would run headless or with a simple RCP to schedule the
process.

I would appreciate any hint, on the steps taken.

rgds Christophe Bouhier

Report message to a moderator

Re: Ad-hoc ODBC to Ecore model [message #532849 is a reply to message #532838]

Tue, 11 May 2010 11:09

Ed Merks

Messages: 33141
Registered: July 2009

Senior Member

Christophe,

I suspect that CDO and Teneo could solve this problem for you, so it
would be good to have a look at those first.

Christophe Bouhier wrote:
> Hi,
>
> I am looking for a solution, whereby a connection to a DB, would be a
> data source, which can be easily mapped to ECore and merged into an
> existing model.
>
> My toughts would be to
>
> 1. Create the connection using Eclipse JDT Connectivity.
> 2. Somehow map the retrieved objects into a dynamic ECore. (Note sure
> how yet).
> 3. Use m2m (QVTO) to transform to my target model.
> 4. Use EMF Compare/Merge to load my target model.
>
> Preferably this would run headless or with a simple RCP to schedule
> the process.
>
>
> I would appreciate any hint, on the steps taken.
>
> rgds Christophe Bouhier

Ed Merks
Professional Support: https://www.macromodeling.com/

Report message to a moderator

Re: Ad-hoc ODBC to Ecore model [message #532851 is a reply to message #532849]

Tue, 11 May 2010 11:21

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Last year I had contact with someone who was interested to contribute in this area to Teneo. Unfortunately this never
materialized. So it is still an open topic for Teneo.
Let me know if you are interested to cooperate on this!

gr. Martin

Ed Merks wrote:
> Christophe,
>
> I suspect that CDO and Teneo could solve this problem for you, so it
> would be good to have a look at those first.
>
>
> Christophe Bouhier wrote:
>> Hi,
>>
>> I am looking for a solution, whereby a connection to a DB, would be a
>> data source, which can be easily mapped to ECore and merged into an
>> existing model.
>>
>> My toughts would be to
>>
>> 1. Create the connection using Eclipse JDT Connectivity.
>> 2. Somehow map the retrieved objects into a dynamic ECore. (Note sure
>> how yet).
>> 3. Use m2m (QVTO) to transform to my target model.
>> 4. Use EMF Compare/Merge to load my target model.
>>
>> Preferably this would run headless or with a simple RCP to schedule
>> the process.
>>
>>
>> I would appreciate any hint, on the steps taken.
>>
>> rgds Christophe Bouhier

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org

Report message to a moderator

Re: Ad-hoc ODBC to Ecore model [message #532864 is a reply to message #532851]

Tue, 11 May 2010 12:07

Christophe Bouhier

Messages: 937
Registered: July 2009

Senior Member

Martin Taal wrote:
> Last year I had contact with someone who was interested to contribute in
> this area to Teneo. Unfortunately this never materialized. So it is
> still an open topic for Teneo.
> Let me know if you are interested to cooperate on this!

Yes, I am!

My perception of Teneo, is that it's ORM from Ecore to Relational DB. I
see that Hibernate, however can do the opposite or perhaps even
bi-directional. Would this be what you have in mind to extend Teneo?

rgds Christophe

Report message to a moderator

Re: Ad-hoc ODBC to Ecore model [message #532883 is a reply to message #532849]

Tue, 11 May 2010 12:54

Christophe Bouhier

Messages: 937
Registered: July 2009

Senior Member

Ed Merks wrote:
> Christophe,
>
> I suspect that CDO and Teneo could solve this problem for you, so it
> would be good to have a look at those first.
>
Thanks, I will evaluate CDO, Teneo I am using for Ecore --> RDMS mapping.

Report message to a moderator

Re: Ad-hoc ODBC to Ecore model [message #532931 is a reply to message #532864]

Tue, 11 May 2010 15:20

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Hi Christophe,
The idea I discussed with the other party was a conversion from db schema to ecore including Teneo annotations (in the
model). This made it possible to persist the instances again in the same database. The party I talked with had developed
this as an in-house tools.

When doing this there are some heuristics which can be thought of (for example auto-detect join tables).
A variant could be a hbm --> ecore conversion. There are tools out there to generate a hbm from a db schema. Then from
the hbm an ecore model can be created also.

gr. Martin

Christophe Bouhier wrote:
> Martin Taal wrote:
>> Last year I had contact with someone who was interested to contribute
>> in this area to Teneo. Unfortunately this never materialized. So it is
>> still an open topic for Teneo.
>> Let me know if you are interested to cooperate on this!
>
> Yes, I am!
>
> My perception of Teneo, is that it's ORM from Ecore to Relational DB. I
> see that Hibernate, however can do the opposite or perhaps even
> bi-directional. Would this be what you have in mind to extend Teneo?
>
> rgds Christophe
>
>
>

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org

Report message to a moderator

Previous Topic:	How to model a simple list that does not need notification
Next Topic:	Problem with namespace and capitalization during XML serialization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:42:08 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter