Informatica Managed File Transfer Installation Guide

Back Next

Verify the Database Requirements

Verify that your database meets the requirements for running Informatica

Managed File Transfer

The following table describes the database requirements for

Managed File Transfer

Database Component	Description
Database System	Type of database on which to install the repositories. You can use one of the following database systems: Oracle Microsoft SQL Server
Disk space	The database requires at least 512 MB of disk space for the core application. You also need additional space based on the number of messages that you need to process and the type of processing required. The frequency of message archiving also affects the disk space requirement.
Database connections	One or more database connections must always be available. The number of required connections depends on the number of endpoints and the number of documents processed concurrently. Use the following formula to calculate the number of required database connections : (NumberOfEndpoints + Maximum number of concurrent processes + 3) X 3 + 2 If you do not have enough database connections available, processing might fail or you might encounter database deadlocks. The default number of database connections is 2.

If you require Unicode support, create the repository database with the following settings:

Oracle databases: use the AL32UTF8 Unicode character set.

Microsoft SQL Server: it is recommended that you use data types that support Unicode data: nchar, nvarachar, and ntext.

If you use Microsoft SQL Server, the collation for the repository must not be case sensitive.