Installing Dataedo Repository on Azure SQL

Applies to: Dataedo 23.x versions, Article available also for: 24.x (current)

Current implementation of Azure repository 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 to whitelist your IP so the app can access the database. To do this, click Set server firewall when database creation finishes:

Azure firewall

Then, 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 host address by clicking the 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 the server name copied above:

Connect with SSMS

Right-click your database, then choose New query:

New SSMS query

Open the Scripts folder in the Dataedo Desktop installation location (the default path is C:\Program Files (x86)\Dataedo\Scripts), then find the numbered create_repository files:

Create scripts

Go back to the SSMS and execute them in numbered order.

Create repository on Azure

The queries may display warnings, but as long as no actual errors are shown, everything's fine. After that, connect to the repository with Dataedo Desktop. If you encounter any major errors, most likely not every script was correctly executed. In that case, we recommend repeating the creation process described above.

User creation

If you don't need additional user accounts, skip this step.

To connect to the repository, each person connecting must have a database user. Create database users as usual through CREATE USER command in SSMS. Find out more details here.

One way to do it is to switch to the repository database and create a new database user: CREATE USER new_user WITH PASSWORD='92piTCh%$!~3K9844';

After creating the user, add it to the USERS role: EXEC sp_addrolemember 'USERS', 'new_user';

The user can now connect to the repository with the username and password specified above.

Connecting to the repository

Run Dataedo, and double-click the New connection button.

Image title

Fill in the connection details. Use the server name you've previously copied as Host.

Image title

Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.