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 <pritam.k...@hotwaxsystems.com> 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 <xinhuan.zh...@gmail.com> > 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! > > > > >
