Use it Messaging

1. Use itMessaging Databases

2. DM Server databases support • Layout • Supported databases • Database installation specificities • Connection strings description

3. DM Server databases support • Supported databases • Microsoft Access • Five .mdb databases • SQL Server • Five SQL databases • Oracle Server • Five user/schemes • If SQL Server or Oracle Server is chosen, there is no turning back. • In the Access case, migration to SQL Server or Oracle Server is still possible afterward.

4. DM Server databases support • Microsoft Access • Nothing in particular

5. DM Server databases support • SQL Server • Supported versions • MSDE (MS Desktop Engine) • SQL Server 2005 Express • SQL Server 2000 • SQL Server 2005

6. DM Server databases support • SQL Server • Installation • 3 choices : • 1. Creation of everythingdatabases & resources (tables, procedures) • 2. Creation of resources(tables, procedures) • 3. Not any creation • 1 and 2 require some credentials for authentication to the SQL Server for the setup stage. • If this is troublesome for security matters, use 3. • In any case, some credentials have to be given in order for DM Server to connect to the databases while running.

7. DM Server databases support • Oracle Server • Installation • 3 choices : • 1. Creation of everythingdatabases, schemes & resources • 2. Creation of resources(tables, procedures) • 3. Not any creation • 1 and 2 require some credentials for authentication to the Oracle Server for the setup stage. • If this is troublesome for security matters, use 3. • In any case, some credentials have to be given in order for DM Server to connect to the databases while running. • 5 users are used for the server connection, each one sharing the same password.They are automatically created in 1, and created via scripts in 2 and 3.They need the CONNECT and RESOURCE roles. • A TABLE_SPACE >= 200MB for each user/schema is advised

8. DM Server databases support • Multiple installations • Allow the sharing of SQL Server or Oracle Server to several DM Server configurations. In order to do a multiple installation, change from the second installation on, the 5 bases default names or users/schemes (Imebase, Ifcomsvc, MiXpeFtp, MiCom, DMArch) by differents names. After the Imecom tree creation by Setup.exe, and before running SetupSvr.exe, add to the new config.cfg the 5 sections containing the new names in the DBName values. Example : [Database.Imebase] DBName=Imebase_2 [Database.Ifcomsvc] DBName=Ifcomsvc_2 [Database.DMArch] DBName=DMArch_2 [Database.MiXpeFtp] DBName=MiXpeFtp_2 [Database.MiCom] DBName=MiCom_2 Note: to solve possible name conflicts, it is possible to change the 5 default bases names or users/schemes since the first installation.

9. DM Server databases support • Migration :Access to SQL Server or Oracle Server • Two phases • Mdb2SQL or Mdb2Ora • DBUpdate

10. DM Server databases support • Connection strings description • File config.cfg • Contains the list of every database or user/scheme in the [Databases] section [Databases] Base1=Imebase Base2=Ifcomsvc Base3=Micom Base4=MiXpeFtp Base5=Dmarch

11. DM Server databases support • Connection strings description • Section for each database or user/scheme containing :

12. DM Server databases support • Connection strings description • Imebase connection samples • Access [DataBase.Imebase] Server= SQLSecurity=0 SQLLogin= SQLPwd= DBName=Imebase SqlConnect= SqlDataType=0

13. DM Server databases support • Connection strings description • Imebase connection samples • SQL Server Trusted_Connection [DataBase.Imebase] Server=WBERNIERGTEST SQLSecurity=0 SQLLogin= SQLPwd= DBName=Imebase SqlConnect=DRIVER={SQL SERVER}; SERVER=WBERNIERGTEST; DATABASE=Imebase; Trusted_Connection=yes SqlDataType=1 [DataBase.Imebase] Server=WBERNIERGTEST SQLSecurity=1 SQLLogin=faxuser SQLPwd=7a2§2#§_6C6>7E7B7@6B7? DBName=Imebase SqlConnect=DRIVER={SQL SERVER}; SERVER=WBERNIERGTEST; DATABASE=Imebase; UID=faxuser; PWD=7a2§2#§_6C6>7E7B7@6B7? SqlDataType=1 ID/password

14. DM Server databases support • Connection strings description • Imebase connection samples • Oracle Server [DataBase.Imebase] OracleDriver=Oracle dans OraHome92 OracleService=dbtest SQLPwd=a96§cc§h6o6>7@7B6q6F DBName=Imebase SQLLogin=Imebase SqlConnect=DRIVER={Oracle dans OraHome92}; DBQ=dbtest; UID=Imebase; PWD=a96§cc§h6o6>7@7B6q6F SqlDataType=2

15. DM Server databases support • Connection strings description • Registry The registry mirror some of values used in the config.cfg file

16. DM Server databases support • Connection strings description • Registry For each database or user/scheme, these values are located under the keys : HKEY_LOCAL_MACHINE\SOFTWARE\imecom\Imemail\Version5\Default\Databases\Controller HKEY_LOCAL_MACHINE\SOFTWARE\imecom\Imemail\Version5\Default\Databases\DMArch HKEY_LOCAL_MACHINE\SOFTWARE\imecom\Imemail\Version5\Default\Databases\IFCOMSVC HKEY_LOCAL_MACHINE\SOFTWARE\imecom\Imemail\Version5\Default\Databases\MICOM HKEY_LOCAL_MACHINE\SOFTWARE\imecom\Imemail\Version5\Default\Databases\XPEDITE For Ifcomsvc only, these values are located under the key : HKEY_LOCAL_MACHINE\SOFTWARE\imecom\IFCOMSVC

17. DM Server databases support • Connection strings description • Registry - Imebase connection samples • Access mode

18. DM Server databases support • Connection strings description • Registry - Imebase connection samples • SQL Server mode Trusted_Connection ID/password

19. DM Server databases support • Connection strings description • Registry - Imebase connection samples • Oracle Server mode