Experiences using OFBiz with MS SQL

[Michael Brohl-3]

Hi all,

we are about to migrate a customer using OFBiz with an older MaxDB
(SAPDB) to use MS SQL as the customer's preferred target database.

Do you have experience running OFBiz with a MS SQL database in production?
Any incompatibilities, disadvantages or problems?

Thanks for sharing you experiences,
kind regards,

Michael

[Jacques Le Roux]

Hi Michael

I have no production experience with MS SQL, but here is a markmail search which might help you
http://ofbiz.markmail.org/search/?q=%22+MS+SQL%22#query:%22%20MS%20SQL%22+page:1+mid:5i2pbzavzwkhc3as+state:results

Jacques

Le 27/02/2015 09:14, Michael Brohl a écrit :

> Hi all,
>
> we are about to migrate a customer using OFBiz with an older MaxDB (SAPDB) to use MS SQL as the customer's preferred target database.
>
> Do you have experience running OFBiz with a MS SQL database in production?
> Any incompatibilities, disadvantages or problems?
>
> Thanks for sharing you experiences,
> kind regards,
>
> Michael
>
>

[taher]

Hi Michael,

Out of curiosity, why would the client gravitate to an open source solution
sitting on a proprietary database? Especially given that they are migrating!

Taher Alkhateeb
On Feb 27, 2015 11:54 AM, "Jacques Le Roux" <[hidden email]>
wrote:

> Hi Michael
>
> I have no production experience with MS SQL, but here is a markmail search
> which might help you
> http://ofbiz.markmail.org/search/?q=%22+MS+SQL%22#query:
> %22%20MS%20SQL%22+page:1+mid:5i2pbzavzwkhc3as+state:results
>
> Jacques
>
> Le 27/02/2015 09:14, Michael Brohl a écrit :
>
>> Hi all,
>>
>> we are about to migrate a customer using OFBiz with an older MaxDB
>> (SAPDB) to use MS SQL as the customer's preferred target database.
>>
>> Do you have experience running OFBiz with a MS SQL database in production?
>> Any incompatibilities, disadvantages or problems?
>>
>> Thanks for sharing you experiences,
>> kind regards,
>>
>> Michael
>>
>>
>>

[Michael Brohl-3]

Hi Jaques,

thank you! Most of the hits are quite old but maybe there are some good
pointers.

Regards,

Michael

Am 27.02.15 um 09:53 schrieb Jacques Le Roux:
> Hi Michael
>
> I have no production experience with MS SQL, but here is a markmail
> search which might help you
> http://ofbiz.markmail.org/search/?q=%22+MS+SQL%22#query:%22%20MS%20SQL%22+page:1+mid:5i2pbzavzwkhc3as+state:results 
>
>
> Jacques

[Pierre Smits]

This might be a reason:

In October 2007, SAP assumed full sales and commercial support for MaxDB.
MaxDB 7.6 is now closed source <https://en.wikipedia.org/wiki/Closed_source>,
available free-of-charge (without support, and with usage restrictions) for
use with non-SAP applications.

As quoted from  https://en.wikipedia.org/wiki/MaxDB

Best regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Fri, Feb 27, 2015 at 10:04 AM, Taher Alkhateeb <
[hidden email]> wrote:

> Hi Michael,
>
> Out of curiosity, why would the client gravitate to an open source solution
> sitting on a proprietary database? Especially given that they are
> migrating!
>
> Taher Alkhateeb
> On Feb 27, 2015 11:54 AM, "Jacques Le Roux" <[hidden email]>
> wrote:
>
> > Hi Michael
> >
> > I have no production experience with MS SQL, but here is a markmail
> search
> > which might help you
> > http://ofbiz.markmail.org/search/?q=%22+MS+SQL%22#query:
> > %22%20MS%20SQL%22+page:1+mid:5i2pbzavzwkhc3as+state:results
> >
> > Jacques
> >
> > Le 27/02/2015 09:14, Michael Brohl a écrit :
> >
> >> Hi all,
> >>
> >> we are about to migrate a customer using OFBiz with an older MaxDB
> >> (SAPDB) to use MS SQL as the customer's preferred target database.
> >>
> >> Do you have experience running OFBiz with a MS SQL database in
> production?
> >> Any incompatibilities, disadvantages or problems?
> >>
> >> Thanks for sharing you experiences,
> >> kind regards,
> >>
> >> Michael
> >>
> >>
> >>
>

[Michael Brohl-3]

Hi Taher,

MS SQL is not open source. The OFBiz solution has a long history and
they started with SAPDB because it was available for them at the time
(they use SAP as ERP). There are several issues with this setting so
they setup a project to change. They wish to change to MS SQL because
their operations department has the know-how to operate this database.

Michael

Am 27.02.15 um 10:04 schrieb Taher Alkhateeb:
> Hi Michael,
>
> Out of curiosity, why would the client gravitate to an open source solution
> sitting on a proprietary database? Especially given that they are migrating!
>
> Taher Alkhateeb

[Jacques Le Roux]

The Entity Engine did not change much from that times, I believe most is still valid, but I don't know for the MS SQL side.

Jacques

Le 27/02/2015 10:12, Michael Brohl a écrit :

> Hi Jaques,
>
> thank you! Most of the hits are quite old but maybe there are some good pointers.
>
> Regards,
>
> Michael
>
> Am 27.02.15 um 09:53 schrieb Jacques Le Roux:
>> Hi Michael
>>
>> I have no production experience with MS SQL, but here is a markmail search which might help you
>> http://ofbiz.markmail.org/search/?q=%22+MS+SQL%22#query:%22%20MS%20SQL%22+page:1+mid:5i2pbzavzwkhc3as+state:results
>>
>> Jacques
>

[Pierre Smits]

Hi Michael,

Could you elaborate a bit on how OFBiz fits in their architecture (e.g.
purpose wise)?

Best regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com

On Fri, Feb 27, 2015 at 10:21 AM, Michael Brohl <[hidden email]>
wrote:

> Hi Taher,
>
> MS SQL is not open source. The OFBiz solution has a long history and they
> started with SAPDB because it was available for them at the time (they use
> SAP as ERP). There are several issues with this setting so they setup a
> project to change. They wish to change to MS SQL because their operations
> department has the know-how to operate this database.
>
> Michael
>
> Am 27.02.15 um 10:04 schrieb Taher Alkhateeb:
>
>  Hi Michael,
>>
>> Out of curiosity, why would the client gravitate to an open source
>> solution
>> sitting on a proprietary database? Especially given that they are
>> migrating!
>>
>> Taher Alkhateeb
>>
>
>
>

[Michael Brohl-3]

Hi Pierre, all,

just a brief overview: they are a registered cooperative (e.G.) and use
OFBiz as a B2B sales- and portal solution. They offer a web based
solution for their own customers (retailer and warehouses) based on
OFBiz' ecommerce module, integrated with their order management. The
portal provides financial data, invoice check and claim processes with
integration to SAP.

The solution is running for some time now, I think I had my first
project there around mid 2003 :-)

Regards,

Michael
ecomify.de

Am 27.02.15 um 10:36 schrieb Pierre Smits:

> Hi Michael,
>
> Could you elaborate a bit on how OFBiz fits in their architecture (e.g.
> purpose wise)?
>
> Best regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
> On Fri, Feb 27, 2015 at 10:21 AM, Michael Brohl <[hidden email]>
> wrote:
>
>> Hi Taher,
>>
>> MS SQL is not open source. The OFBiz solution has a long history and they
>> started with SAPDB because it was available for them at the time (they use
>> SAP as ERP). There are several issues with this setting so they setup a
>> project to change. They wish to change to MS SQL because their operations
>> department has the know-how to operate this database.
>>
>> Michael
>>
>> Am 27.02.15 um 10:04 schrieb Taher Alkhateeb:
>>
>>   Hi Michael,
>>> Out of curiosity, why would the client gravitate to an open source
>>> solution
>>> sitting on a proprietary database? Especially given that they are
>>> migrating!
>>>
>>> Taher Alkhateeb
>>>
>>
>>