dijexi.com

In order to be successfully installing Adempiere, you must do the following steps on the right order.

1. Fulfill the prerequisites
2. Installing Java Development Kit (JDK)
3. Installing Database (Oracle 10g, 11g, or XE, or PostgreSQL)
4. Setup Adempiere
5. Create Adempiere Database
6. Complete Server Setup

Prerequisites

Adempiere ERP requires the following item to be configured properly:

Sun Java 1.5.0 JDK (not just JRE)

One of the database

• Oracle 10g
• Oracle 11g
• Oracle XE
• Postgresql 8.1 and above

The latest version of ADempiere

Installing Java Development Kit (JDK)

Installation on JDK should be simple, you just need to run the setup program. One thing that you should notice is that you must download the JDK (Java Development Kit), not just the JRE (Java Runtime Environment). Ademipere needs the JDK which consists of full package of Java libraries and development tools.

After installing JDK, you need to make sure of the Windows environment variables JAVA_HOME is correct. This can be done by using Windows command prompt (menu Start – Run – type cmd).

Installing Oracle Database

In this article we are going to use Oracle XE database server. First, you need to download the setup program. Search the keyword (oracle xe download) from google.com or go to Oracle web site: http://www.oracle.com/technology/software/products/database/xe/index.html. You have the option to download either for Linux or Windows operating system. In this article we are going to use Windows.

Detailed instruction for installing Oracle XE can be found in this link.

Setup Adempiere

If you have not downloaded the latest version of Adempiere, you must do it now by clicking this link. After downloading, extract the file to some temporary folder. The extracted folder will contain a folder called Adempiere. Move this folder to a root directory for simplicity, which is in this article C:\. So, you will have a new folder called C:\Adempiere.

Now, open command prompt and type cd c:\adempiere to go to that folder.

On the c:\adempiere folder, type the following command:

RUN_Adempiere.bat

wait until a dialog similar like this appear:

That was the Adempiere server setup dialog. What you need to do on that dialog is to make adjustment to the default parameter values presented on the dialog. The most important parameters are:

1. Java Home: set it to the Java SDK installation path you have done before, for example C:\Java
2. Adempiere Home: set it to the path of the Adempiere installation folder you have done before, for example C:\Adempiere
3. Application server: fill it with the computer name the Adempiere server running on
4. Web Port: type the available port number for the Adempiere web server, for example 8080 (in case Apache is already running on port 80 on your computer)
5. SSL: type the available port number for the SSL port of the application server, for example 8443 (in case Apache SSL is already running on port 443 on your computer)
6. Database Type: select Oracle XE
7. Database system password: fill it with the password of the Oracle’s SYSTEM user which is defined on the Oracle XE installation stage that you must have done before.

You may leave other parameters as default.

After adjusting the parameter, click on the Test button. The program will check all of the parameters and show you indicators whether the values are correct or not. You must adjust them to the correct values depending your system configuration before setup process continue.

When everything is OK, you can now click Save button, which will begin the setup and deployment process.

First, a confirmation will show up:

Click OK. The setup and deployment process will take up several minutes depending on your system specification. You may check for messages appear on the command prompt window where the RUN_setup.bat was run before or just wait until messages like this appear:

Create Adempiere Database

Next you must create the Adempiere database.This is done by running the import command which will import the database structure and data to our Oracle XE database server.

Still in the command prompt window, type the following command:

cd c:\adempiere\utils

RUN_importAdempiere.bat

The process will create Adempiere database on our Oracle XE server, you just have to wait until it finishes.

Complete Server Setup

Next step is to run the Adempiere application server. Type the following command on the command prompt:

cd c:\adempiere\utils

RUN_server2.bat

Wait the process until the application server is up and running.

Testing Adempiere Installation

When everything is ok, you need to test the Adempiere installation. Type the following command on the command prompt:

cd c:\adempiere

RUN_adempiere.bat

If nothing was wrong, a dialog like this will show up:

Adempiere was deployed with a sample database which contains a built-in client setup called Garden. On each client, there are two built in users: GardenAdmin and GardenUser. For testing purpose we will use GardenAdmin user ID with which has a default password of GardenAdmin as well. Click on the Ok button to continue. A dialog like this will show up:

That dialog confirm you for your role, client, organization (department below a client), today’s date, and printer setup. Click ok when all item are confirmed. Next, Adempiere dashboard will show up like this.

That will show a snapshot of your business’ performance today recorded by Adempiere. Next, click on the Menu tab that will show Adempiere main menu like this.

Adempiere menu is arranged by a tree structure. Depending on the user ID, there will be menus which can be expanded to show it’s sub menu. You can browse for a particular menu for a specific function or job by expanding and collapsing the tree. You can also find the menu by searching it by typing the menu on the Lookup field located on the bottom right of the dialog window. Try for example type “purchase order” and press Enter to go to a menu which contains “puchase order”.

Note that Adempiere menu shows different icons for the items. The icon indicated the function of the menu which can be a form window, a report window, a process, or a workflow. For testing purpose, double click the Purchase Order menu to open Purchase Order window like this:

Ok, seems like your Adempiere installation is correct. Now close the PO window, and exit Adempiere if you wish.

Akhmad Daniel Sembiring

vITraining.com – Qualified IT Products, Outsourcing, and Services
Ligarwangi.com – Linux, E-book, Coffee, Gift, etc