entity engine

[Junaid Parikh]

Hello friends;

I new to OfBiz, I'm testing it. Is there something like a database
dictionary / information somewhere to know the databases I'm able to use
with the entity engine.

thank you in advance

[Jacques Le Roux]

Look into entityengine.xml if not found yet

Jacques

From: "Junaid Parikh" <[hidden email]>
> Hello friends;
>
> I new to OfBiz, I'm testing it. Is there something like a database
> dictionary / information somewhere to know the databases I'm able to use
> with the entity engine.
>
> thank you in advance
>

[Paul Foxworthy]

Hi Junaid,

There are only three databases, and one of those is central. As Jacques says, look at entityengine.xml. Are you interested in the data model, in other words what all the entities are and how to use them? Or are you interested in the options for a database management system, such as MySQL, Postgres, etc?

For the data model, here's where to start

https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model

there are diagrams in child pages.

The OFBiz data model is based on the concepts described in The Data Model Resource Book by Len Silverston, especially volume 1. It is worthwhile to read  it. See https://cwiki.apache.org/OFBADMIN/ofbiz-related-books.html for the book and other OFBiz books.

Once you have some understanding, the Web Tools in OFBiz allow you to browse the entities. See

https://demo-trunk.ofbiz.apache.org/webtools/control/entitymaint

on the demo site.

The list of DBMSes that could be used is at

https://fisheye6.atlassian.com/browse/ofbiz/trunk/framework/entity/config/entityengine.xml?hb=true#to117

but most people use Postgres or MySQL.

Hope that helps

Paul Foxworthy

Junaid Parikh wrote

Hello friends;

I new to OfBiz, I'm testing it. Is there something like a database
dictionary / information somewhere to know the databases I'm able to use
with the entity engine.

thank you in advance