Databases (Magic xpi 4.6)

« Go Back


Created ByKnowledge Migration User
Approval Process StatusPublished

Databases (Magic xpi 4.6)

In the Database Support screen, select the Run the scripts to build the database tables now check box to create the database tablespace and tables during the installation. If you do not select this check box, the tables are not created during installation and you need to create them manually later on.

For information about supported databases, see the Compatibility Guide.


Only the MSSQL JDBC driver (JAR file) is provided as part of the Magic xpi installation. For any other DBMS, you must provide the JDBC driver jar.

To work with any of the other internal databases:

  1. Copy the JDBC driver jar file to the following folder:
    <Magic xpi installation>\Runtime\java\DatabaseDrivers

  2. Configure the database settings in the datasource.xml file. Make sure that the driverClassName defined in the datasource.xml is compatible with the JDBC driver.

Then, select the database to be used as your internal Magic xpi database. Magic xpi supports the following databases:

After you select a database, click Next.


The Magic xpi installation creates a subfolder called db and within it nested subfolders for each database supported by Magic xpi. If you previously chose to install the database at a later stage, you can install it from these scripts (under the required database). A Read me file that explains how to run the scripts is included in the folder.

If there was a problem creating the internal database during the Magic xpi installation, a log file will be created under the relevant database folder.

Accessing IBM i Data

To access IBM i data using a language other than English, you should add the following entries to the Magic.ini file's [MAGIC_DBMS] section:

  • DB2/400=7,NotAllowNull,10.3,DB2/400 Parameters,N,,NotLogSync,35,0,NotCheckExist,support\ACS400.[lng]

  • AS400=17,NotAllowNull,10.3,LANGUAGE=support\AS2EB.[lng] NAMING=*SQL NOMSGBOX,N,,NotLogSync,35,0,NotCheckExist,support\ACS400.[lng]

Here, [lng] represents the language that you want to use to access the IBM i data. For example, ger represents German, spn represents Spanish, and heb represents Hebrew.