Lists the data source properties for each supported database provider.
Database Provider | Data Source Properties | Notes |
---|---|---|
Common |
User name |
Set as authentication alias. Set as component managed in the data source. |
Derby Embedded | User name not supported |
Not supported in network deployment. |
Derby Network Server | Used as the default database provider for network deployment. | |
DB2 Universal | Database Name |
The schema value is either set as a custom property curSchema or it is set at the component's data store. The schema does not show for components that do not support it. |
DB2 UDB for iSeries (Native) |
Database Name |
The default database name is *LOCAL. The database name can also be changed to an IASP device name if available. The schema name is set as the custom property LIBRARIES. |
DB2 UDB for iSeries (Toolbox) |
Database Name |
The default database name is *SYSBAS. The database name can also be changed to an IASP device name if available. The schema name translates into the data source property LIBRARIES. Server name translates into the data source property SERVER_NAME. |
DB2 for z/OS v8 |
Database Name |
|
|
Database Name |
Translates to the Oracle data source's URL. The Schema name only shows if supported by component. It will be set on the component's data store. |
Microsoft SQL Server (DataDirect) | Database Name |
|
Microsoft SQL Server (Embedded) | Database Name |
|
Informix Dynamic Server | Database Name |
For more information, see "Data source minimum required settings, by vendor."