Thread: A Dempiere

The good thing about this Open Source ERP solution is that it comes with a lot of support information to help you deploy it. Before implementing, you can get a feel of this product in two ways.

The first option is that you can log on to its online simulator wehuil with 'SuperUser' as user name and 'System' as password. Here you can get acquainted with the interface of ADempiere ERP solution. The other way is to get the ADempiere virtual appliance, and run it on a virtualiation platform like VMware player to get a taste of it. Here also, you'll get a pre-installed, ready-to-run ERP appliance up and running in a few minutes.

Implementation

In this section we will implement ADempiere on Windows. We used a simple machine running Win XP Professional. To start with we will need the latest version of ADempiere. A pre-requisite of this solution is that the system sbould bave Sun Java] .6.0_10 JDK. First install SDK on your system. For tbis one needs to set the environment variables. Right click on 'My Computer' icon on yourdesktop and go to tbe 'Advanced' tab. Here click on 'Environment Variables.' Add two new environment variables witb the following settings:

Variable Name: JAVA HOME

Variable Value: C:\Program File \Java \jdkl.6.0_10

Variable Name: JRE HOME

Variable Value: C:\Program File\Java\jre6

Next step is to set the path

variable C:\Program

Files \Java \jdkl. 6.0_10\bi n; C:\Program

Files \Java \jre6 \bi n \client;C: \Program Files \PostgreSQL \8.2\bi n

One also needs a database. We installed Postgresql in tbis implementation. Oracle Og/llg/XE is also supported by ADempiere. The following settings need to be changed while installing postgresql. Change from 'C' to your local language and instead of SQLANSI select UTF8. Make sure Postgresql is installed as a service. The programming language should be chosen by checking tbe box in front of PLlpgsql and PLiJava. Now tbat the database has been installed. we need to add database 'adempiere.' At start up. click on 'PostgreSQL>pgAdmin IlL Connect to postgresql. At the bottom you will find postgres'. Right click on Login Roles and create a new user "adempiere" with password "adem pi ere" . Check superuser rights plus all boxes below superuser rights.



Now right click database on top and add 'adempiere' both as name and owner with encoding as UTFS. In the 'Adempiere' folder (at C:\Adempiere) run file 'RUN_Setup. bat.' This will bring up :i\dempiere Server Setup' window. Make appropriate changes like database type from oracleXE to postgresql. Database lame from xe to adempiere. Database Password to crdempiere and System Password. 1\lso change the database server to local host. Click on 'Test' button at bollomto check setting: if settings are correct it will show check mark in frontof settings.

Click on 'Save' button to save set¬tings. Move to 'c:\Admepiere\utils' folder and run 'RU I Server2.bal'. Now while server is running. go to 'c:\Adempiere' and run 'RUN_Adempiere'. A login window will pop up, click on red area in front of 'Server'.

On the next window that pops up, change the application host to the IP address of the machine and click on 'Test Application Server'. A green tick means that it is working properly. ow click on 'Test Database' (again look for a green tick). Login using 'System' as both username and password. Click on Ok and we are done.

Open ERP

OpenERP is an Open Source enterprise management software. Earlier it was kndwn as TinyERP, which covered most of the enterprises needs and processes like accounting, HR, sales CRM, inventory etc.

Like Adempiere, TinyERP or Open ERP as now it is known as, is also an open source ERP solution which is available as a single file installation that includes all the req uisite plug-ins or databases needed by the software. From the Open ERP site, download the stable release of TinyERP.

As of now, the present stable release is version 4.2.3.4, so you can opt for all in-one installer by name 'tinyerp-alli none-setup-4.2.3.4.exe' (for Windows). Once you run the installation. it will automatically install PosLgreSQL Server 8.2 for database and also the GTK plugins for rendering the graphical interface of the ERP software.

Aftel: the installation. when you start the tinyERP server and then its client, you have to make one thing sure that the service for PostgreSQL is started and is running through the Windows Service monitor. When the tiny ERP client starts for the 'first time, it prompts to create a IreiN database. From File> Databases> New Database, we can create a new database. Name it as 'pcqdemo'.

After the database has been created, you can login to the ERP server and upon authentication you are asked to create a pronte of your system. The pronte can be of a finance, manufacturing or the software industry.

Once configured. it automates and helps you control all business activities. All business processes like sales that trigger manufacturing orders. accounting entries being updated by stock operations, etc can be integrated through this software.