Table of Contents

Search

  1. Preface
  2. Data Profiling
  3. Profiles
  4. Profile results
  5. Tuning data profiling task performance
  6. Troubleshooting

Data Profiling

Data Profiling

Microsoft SQL Server connection

Microsoft SQL Server connection

To access a Microsoft SQL Server source object and a Microsoft SQL Server source object on Azure, you need to create a Microsoft SQL Server connection to the source object.

Microsoft SQL Server

Configure the following Microsoft SQL Server connection properties to create and run a data profiling task on a Microsoft SQL Server source object:
Property
Value
Runtime Environment
Choose the active Secure Agent.
SQL Server Version
Enter the Microsoft SQL Server database version.
Authentication Mode
Choose
SQL Server
or
Windows Authentication v2
.
User Name
Enter the user name for the database login.
Password
Enter the password for the database login.
Host
Enter the name of the machine that hosts the database server.
Port
Enter the network port number used to connect to the database server. Default is 1433.
Database Name
Enter the database name for the Microsoft SQL Server target.
Schema
Enter the schema used for the target connection.
Code Page
Choose
UTF-8
.

Azure SQL Database

Configure the following Microsoft SQL Server connection properties to create and run a data profiling task on a Azure SQL Database source object:
Property
Value
Runtime Environment
Choose the active Secure Agent.
SQL Server Version
Enter the Azure SQL Server database version.
Authentication Mode
Choose
SQL Server
or
Windows Authentication v2
.
User Name
Enter the user name for the database login.
Password
Enter the password for the database login.
Host
Enter the name of the machine that hosts the database server.
Port
Enter the network port number used to connect to the database server. Default is 1433.
Database Name
Enter the database name for the Microsoft SQL Server target.
Schema
Enter the schema used for the target connection.
Code Page
Choose
UTF-8
.
Encryption Method
Enter
SSL
.
Crypto Protocol Version
Enter
TLSv1.2
.
For more information about the Microsoft SQL Server connection properties, see the help for the Microsoft SQL Server connector.

0 COMMENTS

We’d like to hear from you!