MAXDB Install

Something interesting... I installed this database in my Vista workstation. This is not part of my work but it's nice that I can install this database in my workstation so easily. So, I'll be doing a lot of updating on this from now on.

Installation

As usual, SAP documents can be very confusing (at least for me). I had to dig into the install docs to find out what I need to do, reinstall at least twice just to get things right to follow the tutorial.

So, here it is, totally learned something about this database from an install perspective.

1. Download the free install in SAP website. I would start with the home db of MAXDB, which is MaxDB and SAP liveCache. On the right, click on the link below Download which would take you MaxDB Downloads.

My operating system is Vista (32-bit), so I chose SAP MaxDB 7.6 for Windows (x86, 32-bit. Note that the links may vary in time and it will need a login for it to continue.

While downloading, go to the complete MAXDB Documentation page to read more information.

2. When download completes, execute the downloaded file and go thru the instructions provided here.

3. After setup is finished, download and install DB Manager and SQL Studio.

4. Reboot (as required by install).

5. Run Database Manager (as Admin) and add database instance DEMODB.

6. Connect to DEMODB. The error (below) would occur due to some incompatibility issues with Vista but as soon as you press OK, the status of the database is ONLINE (and colored green).

7. Create additional database users. Follow instructions from this link.
8. Loading Tutorial and Demo Data. From the Database Manager, click on Configuration and click Load Tutorial (more info here.

Check if it's loaded by viewing the table in SQL Studio. From the Database Manager, click menu Tools -> SQL Studio. Connect to the database by clicking the Key icon, supply the necessary login information needed to connect. Click on Indexes, it should have the HOTEL schema.

Ok, gotta go. Til next time.