To create a Microsoft SQL Server database for OPN Systemô XT Server
The OPN System supports McKoi, Microsoft SQL Server, MySQL and Oracle databases. You select the database during the installation the OPN Systemô XT Server: either the embedded database (McKoi), or an external database. If you chose the embedded database, you can change to a different one by creating a new database and configuring it to be used with the OPN Systemô XT Server.
How to create a Microsoft SQL Server database for OPN System™ XT
Server?
Introduction
The OPN System supports McKoi, Microsoft SQL Server, MySQL and Oracle databases. You
select the database during the installation the OPN System™ XT Server: either the embedded
database (McKoi), or an external database. If you chose the embedded database, you can change
to a different one by creating a new database and configuring it to be used with the OPN System™
XT Server.
This document describes the steps to create a new Microsoft SQL Server database to be used with
the OPN System™ XT Server. Here are the steps to create a new database:
1. Download database management tool (if you don’t have one).
2. Modify the sql script to point to the designated database.
3. Run the sql script on your database server.
4. Configure the database on the OPN System™ XT Server.
For instruction how to export data such as the Contact List from the embedded database to a new
database, see the How to export Contact list from McKoi database to Microsoft SQL Server?
document.
Step 1: Download a shareware database management tool
You need a database management tool to create Microsoft SQL Server database and to
export/import the Contact List. You can download the Aqua Data Studio tool from the following link
http://www.aquafold.com/downloads.html (the Windows version).
Step 2: Modify the opn_mssql.sql
The sql script needed to create the database and the tables required by the OPN System™ XT
Server are provided with the OPN System installation.
1. On your desktop, navigate to :/Program Files/antepo/opnserverXT/data/download
Antepo, Inc. | 185 Varick Street, 5th Floor | New York, NY | 10014 | (212) 741-6653 | www.antepo.com
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
2. Open the opn_mssql.sql file in a text editor.
3. In the text editor, click Edit > Replace to change the $DATABASE_NAME$ to the designated
database name, e.g. opnMSSQL:
4. Save the file.
2
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
Step 3: Run the opn_mssql.sql on Microsoft SQL Server
1. Start Aqua Data Studio, and connect to the Microsoft SQL Server.
Enter your Register Server information and click OK.
2. Right-click the Microsoft SQL Server icon and select Query Analyzer.
3
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
The Query Analyzer window is displayed.
4
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
3. Click the Open Script button, or press CRTL-O.
4. Navigate to :/Program Files/antepo/opnserverXT/data/download. The list of sql
scripts is displayed.
5. Select the opn_mssql.sql file and click Open. The sql file is displayed in the Query Analyzer
window.
5
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
6. To run the opn_mssql.sql script, click the Execute button, or press CRTL-E.
7. This creates the OPN database on the Microsoft SQL Server.
Step 4: Configure the Microsoft SQL Server database on the OPN System Server
1. Start the OPN Server Console.
2. Start the Web Configuration Interface and log onto the system.
3. Navigate to Database > Connection and add a new database handler for Microsoft SQL
Server.
Click Save to add the database handler to the configuration.
4. Navigate to Database > Selection and select the newly created Microsoft SQL Server
database for all database selections.
6
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
Appendix – Instructions for MySQL and Oracle databases
The procedures to create a MySQL and Oracle databases are similar to the steps for creating a
Microsoft SQL Server. The only differences are as follows:
1. a different sql file for each database
2. required login information when connecting to the database
sql scripts
Each of the database types has a sql file that you need to:
1. Modify to point to the right database.
2. Run to create the database and the tables needed for the OPN System™ XT Server.
Database sql file
Microsoft SQL Server opn_mssql.sql
My SQL opn_mysql.sql
Oracle opn_oracle.sql
7
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
Connecting to MySQL database
When you connect to the MySQL database using the Aqua Data Studio, you need to enter the
required information in the screen shown below:
Name: OPNMySQL (any arbitrary name of MySQL connection)
Login Name: administrator
Password:
Host: 192.168.1.102 (The IP Address of the MySQL database machine)
Port: (default MySQL port)
Database: (left blank / database is created via the opn_mysql.sql script)
8
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
Connecting to an Oracle database
When you connect to the Oracle database using the Aqua Data Studio, enter the required
information in the screen shown below:
Name: OPNOracle (any arbitrary name of Oracle connection)
Login Name:admin (oracle administrator)
Password:
Host: 192.168.1.102 (The IP Address of the Oracle database machine)
Port: (default Oracle port)
SID: siddb (SID assigned to Oracle DB)
9
How to create a Microsoft SQL Server database for the OPN System™ XT Server?
Disclaimer and Copyright
© 2005, Antepo, Inc. All Rights Reserved.
This document is for informational purposes only, NEITHER ANTEPO, INC. NOR ANY OF ITS
SUBSIDIARIES OR AFFILIATES (COLLECTIVELY .ANTEPO.) MAKE ANY WARRANTIES,
EXPRESS OR IMPLIED, IN THIS DOCUMENT.
Antepo may have patents or pending patents applications, trademarks, copyrights, or other
intellectual property rights covering subject matter embodied in this document. The furnishing of
this document does not give you any license to such patents, trademarks, copyrights, or other
intellectual property rights. Antepo does not make any representation or warranty regarding
specifications in this document or any product or item based on these specifications. Antepo
disclaims all express and implied warranties, including but not limited to the implied warranties of
merchantability, fitness for a particular purpose, and non-infringement. Without limiting the
foregoing, Antepo does not make any warranty of any kind that any item based on these
specifications, or any portion of a specification, will not infringe any copyright, patent, trade secret
or other intellectual property right of any person or entity in any country. It is your responsibility to
seek licenses for such intellectual property rights where appropriate. Antepo shall not be liable for
any damages, (direct, indirect, or otherwise) arising out of or in connection with the use of these
specifications, including liability for lost profit, business interruption, or any other damages
whatsoever. Some jurisdictions do not allow the exclusion or limitation of liability or consequential
or incidental damage; therefore the above limitation may not apply to you.
Antepo and Open Presence Network (OPN) are trademarks and/or registered trademarks of
Antepo, Inc. in the United States and other countries. Other products and company names
mentioned herein may be the trademarks and/or registered trademarks of their respective owners.
About Antepo
Headquartered in New York, NY, Antepo, Inc. is the world’s foremost provider of standards-based,
carrier-class, enterprise IM systems. Antepo Open Presence Network (OPN) Systems allow
companies to employ real-time communications to expedite mission-critical business processes.
The OPN System connects users across protocols and enterprise boundaries, linking fixed and
mobile Instant Messaging environments into interoperable, extended collaborative networks.
Antepo provides software and related professional services to telecommunication companies,
financial institutions and globally diversified companies in the US and internationally.
Antepo, Inc.
185 Varick Street, 5th Floor
New York, NY 10014
(212) 741-6653
www.antepo.com
10