Enterprise Data Catalog Scanner Configuration Guide > Configuring Cloud Resources > Azure Microsoft SQL Server
  

Azure Microsoft SQL Server

Azure Microsoft Azure SQL Database is a managed cloud database.

Objects Extracted

Permissions to Configure the Resource

Before you create an Azure Microsoft SQL resource, configure the permissions for the Azure Microsoft SQL Server database user account that you use to connect to Azure Microsoft SQL Server. Enterprise Data Catalog uses SQL Server authentication to connect to the Azure Microsoft SQL Server database. The user account that you use to connect to Azure Microsoft SQL Server must be an SQL Server login account. Configure the VIEW DEFINITION permission for the user account. Configuring this permission lists all the schemas from where the user can load metadata.
Make sure that you configure the VIEW DEFINITION and CONNECT permissions for the Microsoft SQL Server database user.

Prerequisites

Download the MSSQL JDBC driver JAR files from the Internet and copy the files to the AzureMssqlScanner directory in the <Informatica installation directory>/services/CatalogService/ScannerJars/externalDependencies directory. You must restart the Catalog Service.
Note: If the proxy server used to connect to the data source is SSL enabled, you must download the proxy server certificates on the Informatica domain machine.

Basic Information

The General tab includes the following basic information about the resource:
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.

Resource Connection Properties

The following tables list the properties that you need to configure to add an Azure Microsoft SQL Server resource.
The General tab includes the following properties:
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.
The Metadata Load Settings tab includes the following properties:
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:
  • - Select from List. Select the required schemas from a list of available schemas.
  • - Select using regex. Provide an SQL regular expression to select schemas that match the expression.
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:
  • - True. Select this check box to specify that the resource is configured as case sensitive.
  • - False. Clear this check box to specify that the resource is configured as case insensitive.
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:
  • - Low
  • - Medium
  • - High
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:
  • - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO.
  • - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value should be a number.
  • - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value.
  • - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when pmem is enabled. Default value is 1.
Track Data Source Changes
View metadata source change notifications in Enterprise Data Catalog.
You can enable data discovery for an Azure Microsoft SQL Server resource. For more information, see the Enable Data Discovery topic.
You can enable composite data domain discovery for an Azure Microsoft SQL Server resource. For more information, see the Composite Data Domain Discovery topic.