L'intégration d'ODBC n'est possible qu'avec la licence Merak Professionnelle.
Les principales étapes sont :

1. Création d'une base de données pour Merak
2. Création d'un DSN (Data Source Name)
3. Configuration de Merak pour qu'il utilise la base de données ODBC

1. Creation of Database for Merak

You have to create one database in MS SQL which will be used by Merak. The following steps describe how this is done:

I. Open the SQL Manager and go to the Databases sub-tree

II. Add a new Database by clicking on Action – New Database

III. Enter a name for this new Database (e.g. MerakDB). Other options may remain the same.

Confirm by clicking OK and MerakDB will appear in the Databases sub-tree.

IV. Add a new Login – go to the Security sub-tree – choose Logins – and click on Action – New Login. A new dialog will appear: fill in the Name field (e.g. Merakuser), choose the SQL Server authentication and fill in the password (e.g. merakpass) and set the default database for this login to your database for Merak ( MerakDB in our example)

Set the Database Access for that Login – check the appropriate database checkbox (MerakDB in example) and check the database roles for that database:

db_owner

db_accessadmin

db_securityadmin

db_datareader

db_datawriter

By clicking the OK, Confirm password dialog will appear. Fill the password in a second time and finish creating the Login by clicking OK again.

2. Creation of a System DSN

Go to the Control Panel - Administrative Tools - Data Sources (ODBC) - System DSN - Add

The "Create New Data Source" dialog will open. Choose the driver for your database system ( SQL Server for MS SQL Server 2k)

Clicking on the Finish button will confirm your choice and open a new dialog box. Fill in the Name, Description and choose the SQL server you want to connect to. The name will be used in ODBC settings within Merak.

Click Next and choose the "With SQL Server authentication … " option and fill in the Login ID and password (Merakuser and merakpass in our example).

Again click Next and review the dialog. All the options can stay the same as their default values.

Again click Next and review the dialog. All the options may stay the same as their default values.

Now you can click the Finish button to end the process of the creation of your DSN and in the next dialog you can use the Test Data Source button to test the settings of your DSN.

If the test is completed successfully, you can go to the last step in the setup of ODBC for Merak.

3. Switching Merak to use ODBC

Open Merak Configuration Console and go to System -> Storage -> Accounts tab. Here switch Merak to ODBC and set the right settings in the db.ini (click on "DB.INI File" button)

Set the syntax according to the Example file for db.ini. Set the

MSSQLSyntax=1

to that file. Save and go to "ODBC Settings" dialog and fill in the DSN name, username and password you setup in your "DSN Configuration" delimited by a semi-colon. It is ODBCname;merakuser;merakpass with the settings from steps 1. and 2 that should be used here.

Test the connection and if everything is working fine, save the settings by clicking on OK and go back to ODBC settings and use Create Tables to create the table structure in your database.

Now import the domains/users to the ODBC by clicking on the "Convert To ODBC" button. Press F5 to reload and now Merak should work with your MSSQL DB.