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 user name 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 user name empty, by default, the integrated security signature is used 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 for the database user. |
Host | Host name 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 | Extracts metadata from the data source. |
Enable Source Metadata | Select the option to enable and configure the resource to extract metadata. |
Schema | Optional. Specify the schema that you want to import. Use semicolons (;) to separate multiple schemas. If you do not specify 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. For more information about the filter field, see Source Metadata and Data Profile Filter. |
Azure Blob Container Name | Name of the Azure storage blob container. |
Case Sensitive | Specifies that the resource is configured for case insensitivity. Select one of the following values:
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. |