SAP MaxDB – Now Available for Click Stream Analytics

• September 15, 2011
• No Comments

Through client request, the latest release of the Click Stream analytics business package supports SAP MaxDB.

A Quick Intro to SAP MaxDB

SAP MaxDB is a database management system you can count on to manage your midsize company for current productivity and future growth, without compromising the flexibility your customers have come to expect. Affordable and reliable from start-up, SAP MaxDB self manages so effectively that you also reduce expensive downtime significantly and save on training costs.

SAP MaxDB supports a wide range of operating systems, eliminating the specter of new hardware constraints, consistently winning high marks for usability and performance. And when you choose additional applications from SAP, integration is predictable and comfortable

Click Stream and MaxDB

The Click Stream Development Team discussed the advantages of MaxDB with iTechnology (www.itechnology.de) a company that specialized in developing applications for MaxDB Database. Itechnology recommended MaxDB based on their expertise and experienced with clients in various industries.

• MaxDB is a database management system developed and supported by SAP AG
• It has its focus on the requirements of SAP customers and SAP applications
• It has to pass SAP’s rigorous quality assurance process before being released
• SAP MaxDB can also be used with non-SAP applications for free

For more information, read the SAP MaxDB Community License. Also, SAP MaxDB version 7.8 has been published on SCN and is now available for download.

Features of SAP MaxDB

The database management system scales easily for future increases in business volume, so you don’t lose your responsiveness to customers as your company grows.

• SAP MaxDB Supports interfaces such as SQL92, JDBC and ODBC
• Space management and log backup are automatic
• Support CPU load balanced by default
• Support Multiple log partitions allowing parallel log writing
• Default settings for System monitoring supported
• Support identification of clients running commands
• Automatic recreation of bad indexes is configurable
• Software installations are fully isolated from each other
• Full SQL support
• Transaction Management supported
• Flexible bulk loader
• Hot stand by

Why Should You Consider SAP MaxDB?

SAP MaxDB can meet or exceed stringent performance requirements in both SAP and non-SAP environments:

With SAP MaxDB, you gain a single, proven business management application that   streamlines operations and supports your processes for accounting, sales, purchasing, inventory management, human capital management, and analytical reporting in one user-friendly environment.

• Minimal administration is required to run SAP MaxDB
• Low cost  of ownership and easy maintenance
• Easy  installation of MaxDB on Microsoft Windows, Linux, and UNIX operating Systems
• MaxDB integrates quickly and work seamlessly with a wide variety of enterprise applications
• MaxDB is an less expensive alternative to databases from other vendors

Operating Systems Supported By SAP MaxDB

• SAP MaxDB is available on Microsoft Windows, Linux, and UNIX and for the most prominent hardware platforms (see Getting Started with SAP MaxDB)

Installation of SAP MaxDB

• (see Installation on Microsoft Windows and Linux)
• Installation of MaxDB in Clickstream
• MaxDB was installed on Ubuntu 11.04 following the steps in the installation Document.( see Installation on Microsoft Windows and Linux)
• Also installed is a tool for configuring, managing and monitoring SAP MaxDB Database called Database Studio
• Total installation lasted about 2 Hours.

Configuration of MaxDB for Clickstream

Configuring MaxDB for Click Stream in your portal is quite easy. Simply follow these steps:

• Log on to the Database via Database Studio as Database administrator
• In the context menu of Servers, choose Administration Tasks Create Database
• Create a new database in Simple mode (system default)
• All important database properties are pre-configured, but you can still adjust some of them during the creation of the database
• MaxDB has two user Classes, RESOURCE and STANDARD USERS
• For Clickstream we created Resource user with EXCLUSIVE mode of Connection
• Users belonging to this class can define Data and create database Procedures
• And Grant privileges for their database objects to other database users

Experienced with Database Script for Click Stream

Here is our take-away after using:

• The SQL Scripts for creating the Database tables, Constraints and indexes are syntactically similar to those of Oracle, DB2 and MSSQL
• On the other hand, there existed more similarities with Data Manipulation Language Statement for MSSQL than with Oracle and DB2
• Database functions like “IF EXISTS” are not supported by MaxDB Except as a Conditional Statement “WHERE EXISTS”

For more information, visit the Click Stream home page.

Feel free to leave us your comments below.

---

• ← Previous
• → Next

---

Comments are closed.