Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » Re: newbie question - linking existing database repository to DSL
Re: newbie question - linking existing database repository to DSL [message #430871] Sun, 14 June 2009 14:22 Go to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6690
Registered: July 2009
Senior Member
Steve,

This looks like a EMF, CDO and Teneo question. They are supported in the
EMF newsgroup, which I've added to this thread.

Comments below...


Bill Hinge schrieb:
> Hi
>
> I'm developing a modular DSL based tool, I have a placeholder in my DSL
> for 'legacy things'. I also have (or intend to be given) a database
> containing 'legacy things' but I want to create a reference to 'legacy
> things' in my DSL and have my GMF editor extract information about
> 'legacy things' from a database.
>
> In my scanning through eclipse projects, CDO looks like an interesting
> technology to achieve this goal, am I thinking along the right lines?
Sure, CDO is an interesting technology, but I'm certainly biased :P

If your DSL is modeled with Ecore than you can easily regenerate it with
CDO support, see http://wiki.eclipse.org/Preparing_EMF_Models_for_CDO

>
> Also, if I am given an arbitrary database schema to work from, how easy
> is it to integrate to a DSL, ie do I need to manually derive an ecore
> model of the database schema or is their something that will
> automagically create such an ecore file?
I wonder how you modeled your DSL, if not with Ecore in the first place.
Note that the EMF generator has an option to export an Ecore file for
models imported from other sources like XSD.

I'm really not sure but there's a chance that Teneo can also derive an
Ecore model directly from an existing database schema. Martin?

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper



>
> regards
> Steve
>
> PS by legacy things I mean some structured data that already exists but
> built by someone else and I need to reference in my DSL now or in
> future.


Re: newbie question - linking existing database repository to DSL [message #430872 is a reply to message #430871] Sun, 14 June 2009 14:28 Go to previous messageGo to next message
Bill HingeFriend
Messages: 156
Registered: July 2009
Senior Member
Thanks Eike

I wasn't sure which newsgroup was most appropriate

regards
Steve

Eike Stepper wrote:
> Steve,
>
> This looks like a EMF, CDO and Teneo question. They are supported in the
> EMF newsgroup, which I've added to this thread.
>
> Comments below...
>
>
> Bill Hinge schrieb:
>> Hi
>>
>> I'm developing a modular DSL based tool, I have a placeholder in my DSL
>> for 'legacy things'. I also have (or intend to be given) a database
>> containing 'legacy things' but I want to create a reference to 'legacy
>> things' in my DSL and have my GMF editor extract information about
>> 'legacy things' from a database.
>>
>> In my scanning through eclipse projects, CDO looks like an interesting
>> technology to achieve this goal, am I thinking along the right lines?
> Sure, CDO is an interesting technology, but I'm certainly biased :P
>
> If your DSL is modeled with Ecore than you can easily regenerate it with
> CDO support, see http://wiki.eclipse.org/Preparing_EMF_Models_for_CDO
>
>> Also, if I am given an arbitrary database schema to work from, how easy
>> is it to integrate to a DSL, ie do I need to manually derive an ecore
>> model of the database schema or is their something that will
>> automagically create such an ecore file?
> I wonder how you modeled your DSL, if not with Ecore in the first place.
> Note that the EMF generator has an option to export an Ecore file for
> models imported from other sources like XSD.
>
> I'm really not sure but there's a chance that Teneo can also derive an
> Ecore model directly from an existing database schema. Martin?
>
> Cheers
> /Eike
>
> ----
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>
>> regards
>> Steve
>>
>> PS by legacy things I mean some structured data that already exists but
>> built by someone else and I need to reference in my DSL now or in
>> future.
Re: newbie question - linking existing database repository to DSL [message #430873 is a reply to message #430871] Sun, 14 June 2009 20:03 Go to previous messageGo to next message
Martin Taal is currently offline Martin TaalFriend
Messages: 5468
Registered: July 2009
Senior Member
Hi Eike,
No Teneo can not derive an ecore from a database schema. It is on the wish list for a while though and I have someone
willing to contribute code for this. However, the timeline of this is unclear at the moment.

gr. Martin

Eike Stepper wrote:
> Steve,
>
> This looks like a EMF, CDO and Teneo question. They are supported in the
> EMF newsgroup, which I've added to this thread.
>
> Comments below...
>
>
> Bill Hinge schrieb:
>> Hi
>>
>> I'm developing a modular DSL based tool, I have a placeholder in my DSL
>> for 'legacy things'. I also have (or intend to be given) a database
>> containing 'legacy things' but I want to create a reference to 'legacy
>> things' in my DSL and have my GMF editor extract information about
>> 'legacy things' from a database.
>>
>> In my scanning through eclipse projects, CDO looks like an interesting
>> technology to achieve this goal, am I thinking along the right lines?
> Sure, CDO is an interesting technology, but I'm certainly biased :P
>
> If your DSL is modeled with Ecore than you can easily regenerate it with
> CDO support, see http://wiki.eclipse.org/Preparing_EMF_Models_for_CDO
>
>> Also, if I am given an arbitrary database schema to work from, how easy
>> is it to integrate to a DSL, ie do I need to manually derive an ecore
>> model of the database schema or is their something that will
>> automagically create such an ecore file?
> I wonder how you modeled your DSL, if not with Ecore in the first place.
> Note that the EMF generator has an option to export an Ecore file for
> models imported from other sources like XSD.
>
> I'm really not sure but there's a chance that Teneo can also derive an
> Ecore model directly from an existing database schema. Martin?
>
> Cheers
> /Eike
>
> ----
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>
>> regards
>> Steve
>>
>> PS by legacy things I mean some structured data that already exists but
>> built by someone else and I need to reference in my DSL now or in
>> future.


--

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
Re: newbie question - linking existing database repository to DSL [message #430874 is a reply to message #430873] Sun, 14 June 2009 21:04 Go to previous message
Bill HingeFriend
Messages: 156
Registered: July 2009
Senior Member
Thanks Martin, Eike

Just to clarify my DSL was written in ecore, however I wish to decorate
it with new features, eg my current DSL has features called Tasks which
are fixed and based on Enums. However, legacy Tasks may exist which
predate the creation of the DSL, these may exist in a database catalog
hence if I have LegacyTask defined in my DSL I hope to have an
EReference to an ecore derived from the database (my DSL is modular
consisting of multiple ecore, in theory making it straightforward to
add new functional blocks).

I would have been nice to derive ecore from a database, however if it
is not possible at the moment then this is useful to know and I can
follow plan B.

regards
Steve



Martin Taal wrote:
> Hi Eike,
> No Teneo can not derive an ecore from a database schema. It is on the
> wish list for a while though and I have someone willing to contribute
> code for this. However, the timeline of this is unclear at the moment.
>
> gr. Martin
>
> Eike Stepper wrote:
>> Steve,
>>
>> This looks like a EMF, CDO and Teneo question. They are supported in the
>> EMF newsgroup, which I've added to this thread.
>>
>> Comments below...
>>
>>
>> Bill Hinge schrieb:
>>> Hi
>>>
>>> I'm developing a modular DSL based tool, I have a placeholder in my DSL
>>> for 'legacy things'. I also have (or intend to be given) a database
>>> containing 'legacy things' but I want to create a reference to 'legacy
>>> things' in my DSL and have my GMF editor extract information about
>>> 'legacy things' from a database.
>>>
>>> In my scanning through eclipse projects, CDO looks like an interesting
>>> technology to achieve this goal, am I thinking along the right lines?
>> Sure, CDO is an interesting technology, but I'm certainly biased :P
>>
>> If your DSL is modeled with Ecore than you can easily regenerate it with
>> CDO support, see http://wiki.eclipse.org/Preparing_EMF_Models_for_CDO
>>
>>> Also, if I am given an arbitrary database schema to work from, how easy
>>> is it to integrate to a DSL, ie do I need to manually derive an ecore
>>> model of the database schema or is their something that will
>>> automagically create such an ecore file?
>> I wonder how you modeled your DSL, if not with Ecore in the first place.
>> Note that the EMF generator has an option to export an Ecore file for
>> models imported from other sources like XSD.
>>
>> I'm really not sure but there's a chance that Teneo can also derive an
>> Ecore model directly from an existing database schema. Martin?
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>
>>> regards
>>> Steve
>>>
>>> PS by legacy things I mean some structured data that already exists but
>>> built by someone else and I need to reference in my DSL now or in
>>> future.
>
>
Previous Topic:Problems with Dynamic EObject
Next Topic:[TENEO] EMF, Association, Update and Resources
Goto Forum:
  


Current Time: Thu Sep 19 15:18:10 GMT 2024

Powered by FUDForum. Page generated in 0.03245 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top