Connection parameters and other items to define for a SQL Transformation project.
| Property | Description |
|---|---|
| Interface | Specify the method or driver to use to connect to the Sybase IQ target. |
| Host Name | Specify the host where the Sybase IQ target is running. |
| User | Identify an authorized database user. |
The Optional Properties table identifies the properties that are not manadatory for a SQL Transformation project.
| Property | Description |
|---|---|
| Profile | Subscribe to a database connection profile. See Managing Database Connection Profiles. |
| Password | Authorize database user and protect the database against unauthorized access. |
| Database | Identify the database to use as datasource. |
| Schema | Identify the schema or owner you want to use as datasource. |
| Database Options | Set options that override performance defaults and control the behavior of some transactions. |
| SQL Script | Generated SQL script sent to database for execution. |
| SQL Stored Procedure | Store the automatically generated stored procedure. |
| Transactional | Set to perform all operations in a single database transaction that is committed when the project finishes normally. |