Information | Description |
---|---|
Name | The name of the resource. |
Description | The description of the resource. |
Resource type | The type of the resource. |
Execute On | You can choose to execute on the default catalog server or offline. |
Property | Description |
---|---|
User | The username that you need to specify to connect to the Microsoft SQL Server database. If you use a Microsoft SQL bridge to connect to the database and leave the username empty, Enterprise Data Catalog uses the integrated security signature to connect to the database. An integrated security uses the following signature for connection: jdbc:sqlserver://;integratedSecurity=true instead of the jdbc:sqlserver://;user=userid;password=userpassword signature. |
Password | The password that you use for the database user. |
Host | Hostname or IP address of the machine where Microsoft SQL Server is running. |
Port | The port number of the Microsoft SQL server database engine service. Default is 1433. It is recommended that you specify the port number when you connect using the Instance property. If you specify both the Port and the Instance properties, Enterprise Data Catalog uses the Port property. |
Database | The name of the database from which you want to import metadata. Enterprise Data Catalog imports the tables and schemas from the database. |
Instance | Optional. The instance name of the Microsoft SQL Server. You can alternatively specify the port number of the instance. It is recommended that you specify the port number of the instance. |
Connect through a proxy server | Proxy server to connect to the data source. Default is Disabled. |
Proxy Host | Host name or IP address of the proxy server. |
Proxy Port | Port number of the proxy server. |
Proxy User Name | Required for authenticated proxy. Authenticated user name to connect to the proxy server. |
Proxy Password | Required for authenticated proxy. Password for the authenticated user name. |
Property | Description |
---|---|
Enable Source Metadata | Select to extract metadata from the data source. |
Import system objects | Optional. Select this option to import system objects. By default, Enterprise Data Catalog does not import system objects. |
Schema | (Optional) Click Select to specify the schemas that you want to import. You can use one of the following options from the Select Schema dialog box to import the schemas:
If you do not specify the schemas, Enterprise Data Catalog imports all schemas. |
Source Metadata Filter | You can include or exclude tables and views from the resource run. Use semicolons (;) to separate the table names and view names. |
Import stored procedures | Select this property to import stored procedures. Enterprise Data Catalog does not import stored procedures by default. |
Case Sensitive | Specifies that the resource is configured for case insensitivity. Select one of the following values:
The default value is False. |
Memory | The memory required to run the scanner job. Select one of the following values based on the imported data set size:
Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal |
Custom Options | JVM parameters that you can set to configure scanner container. Use the following arguments to configure the parameters:
|
Track Data Source Changes | View metadata source change notifications in Enterprise Data Catalog. |