Database Server Installation

Before installing the IndySoft applications on each workstation, you must first create your IndySoft database. This is an important step that might already have been performed by a DBA - if so, then please proceed to the next topic.

IndySoft supports three different database types - Note the section appropriate to your desired database type below:

·MSSQL Server

·Oracle Server

·Firebird Server

Installing the IndySoft database on an MSSQL Server

Before installing the IndySoft applications on each workstation, you must first create your IndySoft database in MS-SQL Server.

Note: This document is not a replacement for your existing MS-SQL Server documentation. A working knowledge of setting up an MS-SQL Server database is assumed.

First, create your IndySoft database. You may call the database whatever you like - for the purpose of these installation instructions, we will call it 'INDYSOFT'. When creating the database size, if you're unsure what to use for an empty database size, we suggest choosing 200MB. MSSQL Server is intelligent enough to expand this value if necessary. Next, create or note the username/password that will be used by IndySoft clients (or the application server) to make a connection to the database. You will need to enter this new username and password in Database Settings after installing your IndySoft client(s).

Once the database has been created, you must use the table creation scripts located in the root of your IndySoft CD (or downloaded from the IndySoft website) to create the IndySoft table structures. The name of the script you will need to run is MSSQL.SQL. Open the script in the MS-SQL Query analyzer. (Ensure you are logged in to the MS SQL Query analyzer with System Administrator access.) After loading it, ensure you are pointed towards the INDYSOFT database and run the script.

Important: It is suggested that the schema be created while logged into SQL Server as a System Administrator - with 'dbo' being the owner of the database tables/functions. If 'dbo' is NOT the owner of the objects, then it will be required to enter this database owner name and functions owner name in the Database Settings dialog on every client.

The remaining default application data will be input the first time you log into IndySoft.

Installing the IndySoft database on an Oracle Server

Before installing the IndySoft applications on each workstation, you must first create your IndySoft database on your Oracle server.

Note: This document is not a replacement for your existing Oracle documentation. A working knowledge of setting up an Oracle database is assumed.

First, create a new database for IndySoft and a user name to connect to the database. We suggest starting with a tablespace size of at least 12000 megabytes for data and 100 MB for temp tablespace. Note the username/password used to connect to the database - these credentials will later be used in Database Settings or Application Server setup for connecting to the database.

Once the database has been created, you must use the table creation scripts located in the root of your IndySoft CD (or downloaded from the IndySoft website) to create the IndySoft table structures. The name of the script you will need to run is ORACLE.SQL. Start Oracle's SQL*Plus and log in to the new database. To run the ORACLE.SQL script, enter: @'D:\ORACLE.SQL' - Replace 'D:' with the appropriate location of the ORACLE.SQL file on your CD. The script will begin running when you press enter. Each IndySoft table and the relevant indexes, default values, and table relationships will be created.

Important: It is suggested that the user name used to create/own the Oracle objects for IndySoft is the same user name used in Database Settings for connecting to the database. If this is not the case, each workstation must further declare the Database Owner name and Database Functions Owner in Database Settings.

The remaining default application data will be input the first time you log into IndySoft.

Installing the IndySoft database on a Firebird Server

To install the IndySoft database, you must execute the IndySoft Firebird Multi-User installation. This install will not only provide you with the Firebird service/database used for IndySoft, but it will also copy an initial IndySoft Firebird database. So, a database does not need to be created - the install does that for you. You will note the location of this new database so it can be referenced later from IndySoft client installations in their Database Connectivity - Multi-User Firebird 2-Tier step. |