Run Dataedo Desktop and Web Catalog on AWS

Marcin Gaweł - Dataedo Team Marcin Gaweł 26th January, 2023
Applies to: Dataedo 10.x versions, Article available also for: 24.x (current), 23.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

This tutorial is a step-by-step guide to running Dataedo Web Catalog and Dataedo Desktop on AWS. Following this tutorial will install Dataedo Web, a free SQL Server 2019 Express instance, and configure it for local use (no access from other machines in the network). If this doesn't fit your needs, check the other guides here.

First, go to AWS Marketplace and search for "Dataedo". You should a page looking like this:

Image title

To start, select "Continue to Subscribe". If prompted, log in or create a new account as needed.

Then choose "Continue to Configuration":

Image title

On the next screen, select the region that you want to use. Don't change the software version. Click "Continue to Launch".

Image title

On the next screen we have few configuration options, let go one by one:

Here you can select how you want to lunch our application. We will follow the easiest one - "Launch from Website". If you feel more comfortable in EC2 menu, you can chose that option instead.

Image title

Next, select Instance Type - it's the hardware of the server we are about to run. We recommend using at least 4 vCPUs and 16GB RAM to ensure the best performance.

Image title

You need to define Virtual Private Network and the Subnet in the next two options. If you are unsure which one to use, ask your IT administrator.

If you are not using any VPN connection to AWS, you will also need public IP so you can connect to it outside of AWS private network, VPC can automatically assign public IP or you can manually assign it after configuration.

Image title

Security Group Settings - here you can specify which ports for which IPs will be open on the machine (note that this is not Windows Firewall - this is separate level of security on AWS level), if you don't have any configured already click "

Ports that should be open:

  • 80 - to allow HTTP access to Dataedo Web
  • 443 - to allow HTTPS access to Dataedo Web
  • 1433 - to allow SQL connection to SQL repository from Dataedo Desktop (only from different sources then Dataedo Desktop on this server)
  • 3389 - to allow RDP connection to server

When it comes to IPs 0.0.0.0/0 will allow all people around the word to see/try to connect to your instance. Please check with your Network team/IT Administrator which IP range you should use.

Image title

Last option will configure Key Pair Settings to allow you to get password to connect to your instance, if you are not sure ask your IT adminstrator for help if this is your personal account you can create new pair and use it.

Image title

All set! You can click Launch!

Now you can click on "EC2 Console" to go to EC2 dashboard and get login credentials to your instance.

Image title

To do that click on the Instance ID name that we just created:

Image title

Then select connect:

Image title

Go to "RDP client" section and select "Get password"

Image title

Here you need to paste the Private key we specify ealier,if you don't have it ask your Administrator about it, after that you should be able to see the password. Now you can click on "Download remote desktop file"

Image title

The file should start to download, click on it to open select "Connect", it will ask you about your password, copy it from AWS page, click OK, and then "Yes". Wait few minutes (5 should be more then enough) so all the configuration is done and you are ready to go! You should see below screen with Dataedo Web URL, Dataedo Desktop and readme file with connection details (don't worry they are all unique).

Image title