1 / 19

Use it Messaging

Use it Messaging. Databases. DM Server databases support. Layout Supported databases Database installation specificities Connection strings description. DM Server databases support. Supported databases Microsoft Access Five .mdb databases SQL Server Five SQL databases Oracle Server

Download Presentation

Use it Messaging

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related