Category

iDempiere

Migration from ADempiere 3.7 to iDempiere

Comments Off Adempiere ERP iDempiere migration Technical Uncategorized

A Story About Migration

We as a company were using Adempiere 3.7 and we were waiting for the release of 3.8 , we were waiting for the release from 5 years but Adempiere still had Adempiere 3.8 candidate version , which you can consider can not use in production version. Even the community was not active , there were differences between core members of Adempiere so there was a separate fork created. You can read the details here about how & why iDempiere was introduced. Result of this even community for Adempiere started drying up with less responses to the question in the forum. We decided we need to move ahead with the time and with the fast growth of iDempiere 1 to iDempiere 3.1 we were serious migrating from Adempiere 3.7 to iDempiere.

But here was the problem , iDempiere differenced themselves from Adempiere 3.6. So in the simple words iDempiere only provide migration scripts from Adempiere 3.6 to iDempiere. Adempiere 3.7 migration to iDempiere was technically no where provided & biggest problem was we were in oracle and wanted to install iDempiere with postgres ( Go open source ).

We had two options

    • In the first option
        • we can migrate Adempiere 3.7 oracle to Adempiere 3.7 postgres
        • Then Adempiere 3.7 postgres to Adempiere 3.6 ( any how ).
        • Now use the iDempiere migration scripts to migrate

      Surely not the best of the option , very time consuming and repetitive steps.

    • Second option was to directly take data from Adempiere 3.7 oracle and migrate to iDempiere .

I used the second option , We are now live with iDempiere 3.1 migrated from Adempiere 3.7.

Continuous automated migrations

I used Talend for the migration. I created automated jobs with the job flow. This process was/is completely automated.

I ran these migration on different dates for creating different UAT systems.

Things needs to be migrated

  • Customisations ( Window tab and fields )
  • Data ( All the transactional , master , log data )
  • Functionality
  • Reports

If you have any additional questions please free to contact me, drop a comment in the comment box.

Why iDempiere

Comments Off Functional iDempiere Uncategorized
idempiere_home

 

iDempiere is best suitable ERP for small and medium businesses.

Following are the features why I think iDempiere is best.

  1. Active community support https://groups.google.com/forum/#!forum/idempiere
  2. Technical upgrades are very frequent
  3. Plugin architecture , we can plugins for our needs install and play instead of playing and changing or deploying the whole application. The second feature of iDempiere are the plug-ins to modify or extend the ERP, CRM and SCM functionality.
  4. Available plugin library http://wiki.idempiere.org/en/Category:Available_Plugins
  5. CHUCK: it make it easy to do my job… I do not find myself fighting the software

Functional

Most of the customers I work with are between $X and $Y in yearly turnover and operate in distribution and manufacturing industries. iDempiere has the feature set to support this size organization well.

  1. iDempiere is an open source Enterprise Resource Planning (ERP) software. It has also customer relationship management (CRM) and supply chain management (SCM) functions. It is in contrast to proprietary or most other open source ERP solutions driven only by a community of supporters.
  2. Manufacturing – Plugin available manufacturing plugin , Plugin is available here
  3. Use friendly web UI.
  4. iDempiere supports:
    1. Multiple tenants
    2. Multiple organizations (branches, plants, etc.)
    3. Multiple languages (29 localizations; mixed access in a single installation is possible)
    4. Multiple currencies
    5. Multiple accounting schemas

Cost

As an integrator, I do not like dealing with selling software. I know of no customers that like ‘paying’ for software. Because iDempiere is free and open source, I get to specialize in what I do best – help customize iDempiere for specific needs.