DataVeil home

Home    Table of Contents

Connecting to Azure SQL DB

 

DataVeil supports connections to Azure SQL Databases from version V12. DataVeil uses JDBC for connection.

The easiest and quickest way to configure a connection is to copy and paste the JDBC connection string that is provided by Azure from your Azure portal.

To do this, navigate to your Azure SQL Database's 'Connection Settings' tab, and then at the 'JDBC (SQL authentication)' field click on the copy icon.

Show Azure JDBC connection string

 

Next, in the DataVeil connection settings panel paste the copied contents into the JDBC Connection String field.

The copied JDBC string will contain a 'password' field without your actual password. It will appear as 'password={your_password_here}'. Therefore, you will need to replace '{your_password_here}' with your actual password.

DataVeil Azure login credentials

You should now be able to connect to your Azure SQL Database.

If this is your first time connecting to your Azure SQL Database from your current IP address then Azure may reject your connection request in which case you will need to add your current IP address to the corresponding Azure server's firewall.

You may have noticed that the above JDBC connection string leaves your username and password details exposed.

Therefore, it is recommended to remove the username and password details from the JDBC Connection String field and enter them into the corresponding fields in the DataVeil connection form, as shown below. Please note that the part "user=myadminuser@myserver;password=MyPassword;" has been removed from the JDBC Connection String field by the user.

DataVeil can now store the password securely. Please refer to Project Security for further details.

 

Performance


DataVeil's performance will vary greatly according to the performance level configured for the database on Azure (DTUs). This includes not only the mask execution time but also the setup phase of a masking run. Discovery performance is also affected.

 

Database Logging


DataVeil cannot automatically disable Azure transaction logging (unlike SQL Server where DataVeil automatically changes recovery mode to Simple while masking to effectively truncate the log upon each commit). DataVeil generates writes to the transaction log during actual masking runs and also during preview runs.

 

Home    Table of Contents