alright now I get what you mean!
Christian Carlow-OFBizzer wrote > Sorry, > > it's *NOT a viable migration method in my case > > On 01/16/2014 11:42 AM, Christian Carlow wrote: >> 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. >> ----- Jad El Omeiri -- View this message in context: http://ofbiz.135035.n4.nabble.com/JOINs-across-different-DBs-tp4647103p4647321.html Sent from the OFBiz - User mailing list archive at Nabble.com.
