Property | Description |
|---|---|
User name | Database user name. |
Password | Password for the user name. |
Pass-through security enabled | Optional. When enabled, the Data Integration Service connects to a Microsoft SQL Server database with the client user credentials instead of the credentials from a connection object. By default, this option is not selected. |
Use Trusted Connection | Optional. When enabled, the Data Integration Service uses Windows authentication to access the Microsoft SQL Server database. The user name that starts the Data Integration Service must be a valid Windows user with access to the Microsoft SQL Server database. By default, this option is not selected. |
Data Access Connect String | Connection string to preview data and run mappings. Enter <ServerName>@<DBName>. |
Code Page | Database code page. |
Metadata Access Connect String | Connection string to import physical data objects. Use the following connection string: jdbc:informatica:sqlserver://<host>:<port>;SelectMethod=cursor;databaseName=<dbname>. |
Advanced JDBC Security Options | Secure JDBC parameters for the JDBC connection string. |
Environment SQL | Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database. |
Transaction SQL | Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the transaction environment SQL at the beginning of each transaction. |
Domain Name | Optional. Name of the domain where Microsoft SQL Server is running. |
Packet Size | Required. Optimize the ODBC connection to Microsoft SQL Server. Increase the packet size to increase performance. Default is 0. |
Owner Name | The name of the owner of the schema. |
Schema Name | The name of the schema in the database. You must specify the schema name for the Profiling Warehouse and staging database if the schema name is different than the database user name. |
SQL identifier character to use | The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the SSupport mixed-case identifiers property. |
Support mixed case identifiers | When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. By default, this option is selected. |