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

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

Back Next

Using the SQL Wizard

There are two methods to access the SQL Wizard from within

Managed File Transfer

If you want to build a SQL statement without embedding it into a Project, click the

System > Tools > SQL Wizard

link from the main menu bar. You will first be prompted to choose a Database Resource from a list, and then click the

Connect

button. After the connection is established, you can use the tabs to build the parameters of the SQL statement.

Otherwise, if you want to build a SQL statement to embed within a Project, then click the

button next to SQL Statement field on the SQL task's query element from within the Project. You will first be prompted to choose a Database Resource from a list, and then click the

Connect

button. After the connection is established, you can use the tabs to build the parameters of the SQL statement. Finally, click the

Select

button to apply the SQL Statement to the query.

The SQL Wizard page (shown below) is made up of several panels where the schemas, tables, columns, etc. can be selected. You can navigate to a panel by clicking its corresponding tab.

Follow the steps below to use the SQL Wizard.

Tools

Step 1: Choose the Schemas or Libraries

Step 2: Choose the Tables (Physical Files)

Step 3: Choose the Columns (Fields)

Step 4: Choose the Column Headings

Step 5: Specify the Where criteria

Step 6: Specify the Join criteria

Step 7: Specify the Order By criteria

Step 8: Additional tailoring of the SQL statement

Step 9: Test and Generate the SQL statement

Download Guide