What technology do you choose for Party data model?

[Xinhuan Zheng]

I am reviewing Apache OFbiz Data Model book - https://cwiki.apache.org/confluence/download/attachments/13271792/OFBizDatamodelBook_Combined_20171001.pdf?api=v2, Page 8 - 9, the Party, Contact, Communication, and Security data model. One question just comes up into my mind.

Suppose this is a Catalog Order business. It has products of books, DVDs, supplies (for example, certain cups used in certain ceremony) that are all not perishable. When catalogs are printed and sent to prospects, the business takes the order, fulfills the order from inventoried product items. Obviously, the business needs to store product items before orders come in. This will involve in purchase orders from suppliers. This is an outline of the business.

The goal is to keep business process consistent, efficient, and obviously, with limited budget of finance and human resources. So technology is carefully compared, and Apache OFBiz comes out as a potential candidate.

By analyzing the Apache OFbiz Party data model, as the link referenced above, combining with the outlined business process and the goal, what technology do you choose just for Party data model (including Party, Contact, Communication, Security)? I am listing below potential technologies:

1. Microsoft Excel Spreadsheet
2. Microsoft Exchange Database
3. MySQL Database
4. Mongo Database
5. Oracle Database

Thanks!
 

[Pritam Kute]

Hello Xinhuan,

Happy to see that you choose Apache OFBiz for your business needs. Based on
the overall outline of the business you are thinking of, the OFBiz has OOTB
capabilities to fulfil all your requirements.

The question about party data model is little unclear to me but I will
recommend you to go with MySQL database for storing the data. MySQL
integration is seamless with Apache OFBiz and a lot of live projects on top
of Apache OFBiz are using MySQL from years.

Kind Regards,
--
Pritam Kute


On Thu, Jan 7, 2021 at 10:46 PM Xinhuan Zheng <[hidden email]>
wrote:

> I am reviewing Apache OFbiz Data Model book -
> https://cwiki.apache.org/confluence/download/attachments/13271792/OFBizDatamodelBook_Combined_20171001.pdf?api=v2,
> Page 8 - 9, the Party, Contact, Communication, and Security data model. One
> question just comes up into my mind.
>
> Suppose this is a Catalog Order business. It has products of books, DVDs,
> supplies (for example, certain cups used in certain ceremony) that are all
> not perishable. When catalogs are printed and sent to prospects, the
> business takes the order, fulfills the order from inventoried product
> items. Obviously, the business needs to store product items before orders
> come in. This will involve in purchase orders from suppliers. This is an
> outline of the business.
>
> The goal is to keep business process consistent, efficient, and obviously,
> with limited budget of finance and human resources. So technology is
> carefully compared, and Apache OFBiz comes out as a potential candidate.
>
> By analyzing the Apache OFbiz Party data model, as the link referenced
> above, combining with the outlined business process and the goal, what
> technology do you choose just for Party data model (including Party,
> Contact, Communication, Security)? I am listing below potential
> technologies:
>
> 1. Microsoft Excel Spreadsheet
> 2. Microsoft Exchange Database
> 3. MySQL Database
> 4. Mongo Database
> 5. Oracle Database
>
> Thanks!
>
>

[Xinhuan Zheng]

Hello Mr. Pritam,

Thank you for your email. Can you please provide me more resource
information about OFBiz OOTB capabilities?

Sorry for the unclear question about the Party data model. Initially the
business won't have too many product skus, but it will definitely have
limited number of product skus, suppliers, and orders. However, those types
of data won't pour in all at the same time. The very first data to be
stored initially is Party data, like suppliers including those who are
candidates, even though they may not be the real ones. So that's why I
include Excel spreadsheet, or Exchange database. In my mind, the Excel
spreadsheet can store the same kind of Party data, and the Exchange
database can store the communication messages, even without more
sophisticated  technology like MySQL. That's just my understanding. But I
wonder if the community would have the same view as me.

- Xinhuan

On Fri, Jan 8, 2021 at 12:27 AM Pritam Kute <[hidden email]>
wrote:

> Hello Xinhuan,
>
> Happy to see that you choose Apache OFBiz for your business needs. Based on
> the overall outline of the business you are thinking of, the OFBiz has OOTB
> capabilities to fulfil all your requirements.
>
> The question about party data model is little unclear to me but I will
> recommend you to go with MySQL database for storing the data. MySQL
> integration is seamless with Apache OFBiz and a lot of live projects on top
> of Apache OFBiz are using MySQL from years.
>
> Kind Regards,
> --
> Pritam Kute
>
>
> On Thu, Jan 7, 2021 at 10:46 PM Xinhuan Zheng <[hidden email]>
> wrote:
>
> > I am reviewing Apache OFbiz Data Model book -
> >
> https://cwiki.apache.org/confluence/download/attachments/13271792/OFBizDatamodelBook_Combined_20171001.pdf?api=v2
> ,
> > Page 8 - 9, the Party, Contact, Communication, and Security data model.
> One
> > question just comes up into my mind.
> >
> > Suppose this is a Catalog Order business. It has products of books, DVDs,
> > supplies (for example, certain cups used in certain ceremony) that are
> all
> > not perishable. When catalogs are printed and sent to prospects, the
> > business takes the order, fulfills the order from inventoried product
> > items. Obviously, the business needs to store product items before orders
> > come in. This will involve in purchase orders from suppliers. This is an
> > outline of the business.
> >
> > The goal is to keep business process consistent, efficient, and
> obviously,
> > with limited budget of finance and human resources. So technology is
> > carefully compared, and Apache OFBiz comes out as a potential candidate.
> >
> > By analyzing the Apache OFbiz Party data model, as the link referenced
> > above, combining with the outlined business process and the goal, what
> > technology do you choose just for Party data model (including Party,
> > Contact, Communication, Security)? I am listing below potential
> > technologies:
> >
> > 1. Microsoft Excel Spreadsheet
> > 2. Microsoft Exchange Database
> > 3. MySQL Database
> > 4. Mongo Database
> > 5. Oracle Database
> >
> > Thanks!
> >
> >
>

[Pritam Kute]

Hello Xinhuan,

You can refer the official website[1] of the Apache OFBiz to get to know
about OOTB capabilities. Also, I recommend OFBiz Wiki[2] for a better
understanding of OFBiz at technical as well as the business side.

[1] : https://ofbiz.apache.org/index.html
[2] : https://cwiki.apache.org/confluence/display/OFBIZ/Home

Kind Regards,
--
Pritam Kute


On Fri, Jan 8, 2021 at 11:38 PM Xinhuan Zheng <[hidden email]>
wrote:

> Hello Mr. Pritam,
>
> Thank you for your email. Can you please provide me more resource
> information about OFBiz OOTB capabilities?
>
> Sorry for the unclear question about the Party data model. Initially the
> business won't have too many product skus, but it will definitely have
> limited number of product skus, suppliers, and orders. However, those types
> of data won't pour in all at the same time. The very first data to be
> stored initially is Party data, like suppliers including those who are
> candidates, even though they may not be the real ones. So that's why I
> include Excel spreadsheet, or Exchange database. In my mind, the Excel
> spreadsheet can store the same kind of Party data, and the Exchange
> database can store the communication messages, even without more
> sophisticated  technology like MySQL. That's just my understanding. But I
> wonder if the community would have the same view as me.
>
> - Xinhuan
>
> On Fri, Jan 8, 2021 at 12:27 AM Pritam Kute <[hidden email]
> >
> wrote:
>
> > Hello Xinhuan,
> >
> > Happy to see that you choose Apache OFBiz for your business needs. Based
> on
> > the overall outline of the business you are thinking of, the OFBiz has
> OOTB
> > capabilities to fulfil all your requirements.
> >
> > The question about party data model is little unclear to me but I will
> > recommend you to go with MySQL database for storing the data. MySQL
> > integration is seamless with Apache OFBiz and a lot of live projects on
> top
> > of Apache OFBiz are using MySQL from years.
> >
> > Kind Regards,
> > --
> > Pritam Kute
> >
> >
> > On Thu, Jan 7, 2021 at 10:46 PM Xinhuan Zheng <[hidden email]>
> > wrote:
> >
> > > I am reviewing Apache OFbiz Data Model book -
> > >
> >
> https://cwiki.apache.org/confluence/download/attachments/13271792/OFBizDatamodelBook_Combined_20171001.pdf?api=v2
> > ,
> > > Page 8 - 9, the Party, Contact, Communication, and Security data model.
> > One
> > > question just comes up into my mind.
> > >
> > > Suppose this is a Catalog Order business. It has products of books,
> DVDs,
> > > supplies (for example, certain cups used in certain ceremony) that are
> > all
> > > not perishable. When catalogs are printed and sent to prospects, the
> > > business takes the order, fulfills the order from inventoried product
> > > items. Obviously, the business needs to store product items before
> orders
> > > come in. This will involve in purchase orders from suppliers. This is
> an
> > > outline of the business.
> > >
> > > The goal is to keep business process consistent, efficient, and
> > obviously,
> > > with limited budget of finance and human resources. So technology is
> > > carefully compared, and Apache OFBiz comes out as a potential
> candidate.
> > >
> > > By analyzing the Apache OFbiz Party data model, as the link referenced
> > > above, combining with the outlined business process and the goal, what
> > > technology do you choose just for Party data model (including Party,
> > > Contact, Communication, Security)? I am listing below potential
> > > technologies:
> > >
> > > 1. Microsoft Excel Spreadsheet
> > > 2. Microsoft Exchange Database
> > > 3. MySQL Database
> > > 4. Mongo Database
> > > 5. Oracle Database
> > >
> > > Thanks!
> > >
> > >
> >
>

[adityasharma]

Hello Xinhuan,

Adding to Pritam's answer, you can also refer to Big Book for the data
model diagrams.

https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams
https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Diagrams?preview=/13271792/74681796/OFBizDatamodelBook_Combined_20171001.pdf

Also, the documentation from ASCII docs for the business side:
https://ci.apache.org/projects/ofbiz/site/trunk/ofbizdoc/html5/user-manual.html#_party

Thanks and regards,
Aditya Sharma

On Tue, Jan 12, 2021 at 1:06 PM Pritam Kute <[hidden email]>
wrote:

> Hello Xinhuan,
>
> You can refer the official website[1] of the Apache OFBiz to get to know
> about OOTB capabilities. Also, I recommend OFBiz Wiki[2] for a better
> understanding of OFBiz at technical as well as the business side.
>
> [1] : https://ofbiz.apache.org/index.html
> [2] : https://cwiki.apache.org/confluence/display/OFBIZ/Home
>
> Kind Regards,
> --
> Pritam Kute
>
>
> On Fri, Jan 8, 2021 at 11:38 PM Xinhuan Zheng <[hidden email]>
> wrote:
>
> > Hello Mr. Pritam,
> >
> > Thank you for your email. Can you please provide me more resource
> > information about OFBiz OOTB capabilities?
> >
> > Sorry for the unclear question about the Party data model. Initially the
> > business won't have too many product skus, but it will definitely have
> > limited number of product skus, suppliers, and orders. However, those
> types
> > of data won't pour in all at the same time. The very first data to be
> > stored initially is Party data, like suppliers including those who are
> > candidates, even though they may not be the real ones. So that's why I
> > include Excel spreadsheet, or Exchange database. In my mind, the Excel
> > spreadsheet can store the same kind of Party data, and the Exchange
> > database can store the communication messages, even without more
> > sophisticated  technology like MySQL. That's just my understanding. But I
> > wonder if the community would have the same view as me.
> >
> > - Xinhuan
> >
> > On Fri, Jan 8, 2021 at 12:27 AM Pritam Kute <
> [hidden email]
> > >
> > wrote:
> >
> > > Hello Xinhuan,
> > >
> > > Happy to see that you choose Apache OFBiz for your business needs.
> Based
> > on
> > > the overall outline of the business you are thinking of, the OFBiz has
> > OOTB
> > > capabilities to fulfil all your requirements.
> > >
> > > The question about party data model is little unclear to me but I will
> > > recommend you to go with MySQL database for storing the data. MySQL
> > > integration is seamless with Apache OFBiz and a lot of live projects on
> > top
> > > of Apache OFBiz are using MySQL from years.
> > >
> > > Kind Regards,
> > > --
> > > Pritam Kute
> > >
> > >
> > > On Thu, Jan 7, 2021 at 10:46 PM Xinhuan Zheng <[hidden email]
> >
> > > wrote:
> > >
> > > > I am reviewing Apache OFbiz Data Model book -
> > > >
> > >
> >
> https://cwiki.apache.org/confluence/download/attachments/13271792/OFBizDatamodelBook_Combined_20171001.pdf?api=v2
> > > ,
> > > > Page 8 - 9, the Party, Contact, Communication, and Security data
> model.
> > > One
> > > > question just comes up into my mind.
> > > >
> > > > Suppose this is a Catalog Order business. It has products of books,
> > DVDs,
> > > > supplies (for example, certain cups used in certain ceremony) that
> are
> > > all
> > > > not perishable. When catalogs are printed and sent to prospects, the
> > > > business takes the order, fulfills the order from inventoried product
> > > > items. Obviously, the business needs to store product items before
> > orders
> > > > come in. This will involve in purchase orders from suppliers. This is
> > an
> > > > outline of the business.
> > > >
> > > > The goal is to keep business process consistent, efficient, and
> > > obviously,
> > > > with limited budget of finance and human resources. So technology is
> > > > carefully compared, and Apache OFBiz comes out as a potential
> > candidate.
> > > >
> > > > By analyzing the Apache OFbiz Party data model, as the link
> referenced
> > > > above, combining with the outlined business process and the goal,
> what
> > > > technology do you choose just for Party data model (including Party,
> > > > Contact, Communication, Security)? I am listing below potential
> > > > technologies:
> > > >
> > > > 1. Microsoft Excel Spreadsheet
> > > > 2. Microsoft Exchange Database
> > > > 3. MySQL Database
> > > > 4. Mongo Database
> > > > 5. Oracle Database
> > > >
> > > > Thanks!
> > > >
> > > >
> > >
> >
>