Search

Preface
Informatica Managed File Transfer Welcome Overview
- Managed File Transfer General Features
  - Workflow Automation
  - Ad-Hoc File Transfers and Collaboration
- Getting Started
  - Screen Tips
  - Login
Dashboard
Resources
Workflows
Task Reference
Services Overview
Users
Logs and Reports
Encryption
System
Appendix
Glossary Terms
- AES
- Asymmetric
- Asymmetric Cryptology
- Authentication
- Certificate
- Certificate Authority
- CIDR
- Cipher
- Cryptology
- CSV
- Decryption
- Diffie-Hellman/DSS
- Digital Signature
- DSA
- Element
- Encryption
- Fingerprint
- FTP
- FTPS
- Hash Function
- HTTP
- HTTPS
- ICAP
- Icon
- ISO format
- JCE Service Provider
- JDBC drivers
- JKS
- Key
- Key Alias/Key ID
- Key Pair
- Key Store
- MDN
- MMS
- Non-Repudiation
- Passphrase
- PKCS12
- Private Key
- Project
- Public Key
- Public Key Cryptology
- Public Keyring
- RSA
- Run Priority
- SAML
- Secret Key
- Secret Keyring
- Self-Signed Certificate
- SFTP
- Signing
- SMS
- SMTP
- SSH
- SSL
- SSO
- Symmetric
- Symmetric Cryptology
- URL
- Variable
- Verification
- XML

User Guide

User Guide

10.2
- 10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1

Back Next

Database Servers Resource

Database Servers Resource

Managed File Transfer

can connect to a wide variety of database servers including DB2, Oracle, SQL Server, Informix, Sybase, PostgreSQL and MySQL.

Managed File Transfer

connects to database servers over the network using

JDBC drivers

.

Any SQL statement supported by the database server can be issued by

Managed File Transfer

Projects including SELECT, UPDATE, INSERT, DELETE, CALL and CREATE statements.

When defining a database server resource in

Managed File Transfer

, you need to indicate the JDBC driver to use, along with the connection properties (for example, host name, user, password) for that driver.

Only Oracle and SQLServer drivers are included in

Managed File Transfer

. To enable other databases, manually copy the drivers to the path

/informatica/B2B/MFT/server/userdata/databases

.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.