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 <[email protected]> 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 <[email protected]> > 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 < > [email protected] > > > > > 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 <[email protected] > > > > > 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! > > > > > > > > > > > > > >
