Metadata Manager
- Metadata Manager 10.5.2
- All Products
Property
| Description
|
---|---|
User name
| Name of the SQL Server user account used to connect to the Microsoft SQL Server database. The Metadata Manager Service uses SQL Server authentication to connect to the Microsoft SQL Server database.
|
Password
| Password for the user account used to connect to the Microsoft SQL Server database.
|
JDBC connection URL
| JDBC URL used to connect to the Microsoft SQL Server database. Metadata Manager uses this URL to verify connection information to the Microsoft SQL Server database.
The JDBC connection URL uses the following syntax:
|
Connect string
| Connect string used to create a connection to the Microsoft SQL Server database in the PowerCenter repository. Use the following syntax:
Alternatively, you can create an ODBC data source on the machine that runs the PowerCenter Integration Service and specify the data source name (DSN) as the connect string.
|
Secure JDBC parameters
| Secure JDBC parameters that you want to append to the JDBC connection URL. Use this property to specify secure connection parameters such as passwords. Metadata Manager does not display secure parameters or parameter values in the resource configuration properties. Enter the parameters as name=value pairs separated by the delimiter character that the database driver requires. For example:
If secure communication is enabled for the database, enter the secure JDBC parameters in this property.
|
Encoding
| Code page for the Microsoft SQL Server database.
The code page for the resource, the Metadata Manager repository, and the machine where the associated Integration Service for Metadata Manager runs must be the same.
|
Use Trusted Connection
| To authenticate the user credentials using Windows authentication and establish a trusted connection to a Microsoft SQL Server database, select
Use trusted connection .
When you use a trusted connection to connect to a Microsoft SQL Server database, the Metadata Manager Service connects to the repository with the credentials of the user logged in to the machine on which the service is running.
|