Hey Jad,
Concerning view-entities, I mean that in my case I would need the
ability to join the Product.internalName to
externalDbProduct.internalName (just for example). I don't thing the
entity engine allows this period so it defeats the purpose of attempting
to join the external entity in the first place. This is the case for
the majority of external entities so it's a viable migration method in
my case.
On 01/16/2014 11:03 AM, Jad El Omeiri wrote:
Hi Christian,
As you are saying, there's no real open source equivalent to UnityJDBC.
Although it would have been nice to have one, in order to integrate it maybe
with Ofbiz in the future.
Concerning view-entities, to be honest, I don't really know why they can't
be used on different DBs.
BTW, someone has just now mentioned to me that:
/"Postgres now supports Foreign Data Wrappers. You can use regular database
queries to access these data sources like regular tables. Might be worth a
look."/
So as he's saying, you could probably take a look.
Christian Carlow-OFBizzer wrote
Thanks Jad,
I'm looking for any open-source equivalent to UnityJDBC but there
doesn't seem to be much out there. Regardless of using such a tool, I
think the OFBiz entity engine will issues joining the external db due to
incompatible primary keys in the external db. I think view-entities
require joins to be on primary keys. In order for the external db to be
joined in my case it would have to be done on non-primary key fields.
So I think the entity engine would have to be changed to allow such a
tool to be employed within OFBiz, but the design seems deliberate and
correct and unlikely to change from requiring primary key joins.
Importing or using the external db tables directly seem to be the main
alternatives.
On 01/14/2014 10:35 AM, Jad El Omeiri wrote:
Thank you UnityJDBC for your reply.
looks like this is the solution I will be opting for.
I will be soon giving my feedback.
note: did anyone have any experience with Ofbiz/UnityJDBC before? it
would
probably help.
-----
Jad El Omeiri
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/JOINs-across-different-DBs-tp4647103p4647184.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
-----
Jad El Omeiri
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/JOINs-across-different-DBs-tp4647103p4647314.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
