Creating Azure SQL repository

11th June, 2018

Applies to: Dataedo 7.x versions, Article available also for: 10.x (current), 9.x, 8.x

You are looking at documentation for an older release.
Switch to the documentation for Dataedo 10.x (current).

Available from version 7.0.3 beta.

Note that this is a beta feature. If you run into any issues, we’d be happy to hear about them.

Administration Console connection is not currently supported for Azure SQL repositories.

Until now, Dataedo supported file and SQL Server based repository. In 7.0.3 beta, we're adding support for storing repository in Azure SQL Database.

Current implementation requires manual setup, in future releases this process will be included in our repository creator.

Create an Azure SQL Database

To create a repository in Azure, first create an Azure SQL database. Find out more here.

New Azure database

Make sure your IP has access to the database by clicking Set server firewall when database creation finishes.

Azure firewall

Click Add client IP, then Save to add your IP to the whitelist.

Add IP to firewall

After clicking your database name, you can copy its hist address by clicking an icon to the right of Server name field.

Copy the server name

Repository creation

Connect to the database with SQL Server Management Studio (SSMS) using server name copied above.

Connect with SSMS

Right click your database, then choose New query.

New SSMS query

Find the repository creation script named create_repository.sql in Dataedo folder (default path is C:\Program Files (x86)\Dataedo 7\Scripts).

Create script location

Copy the script to SSMS and run it by pressing the F5 key.

Create repository on Azure

You should see a Query executed successfully message.

SSMS query successful

User creation

If you're going to connect to the repository with previously created user, you can skip this step.

Each person connecting to the repository will need to have a database user.

Create database users as usual through CREATE USER command in SSMS. Find out more details here.

Now, add a Lite license to the user by running the command below (substitute johnsmith for the user name):

INSERT INTO [dbo].[licenses] ([login],[key]) VALUES ('johnsmith','BLNFPCMFBGJMLJNFGMCOFICMHLOJGIJLJKNMNHFOMNOBLFFGHDHGGKEHIJDPAAMLKIKGKBKNLAJEBIEFGDEOAPDHAMOFCCCGKFPHHCBDIIPCDMJNKKGACDEGMEDEHKEDDOBJDBLCCBIONEDEHPODFEOEKDCCFOEJDOMCDICBJGOCFGDGEJEKFNBKCFENMLKANHKCOPKFCCKAAKFGFMMIEHALAKBIOAGFNGJGDJOGJODHMCPJDJOCJBKFJHPFIJIN');

You can now connect to the repository through Dataedo with the user.