Install/Uninstall Dimodelo Data Warehouse Modeler

Dimodelo Data Warehouse Modeler is a plug-in for Visual Studio (at the time of publishing, Visual Studio 2015 is supported).

Prerequisites

Because Dimodelo Data Warehouse Modeler is a Visual Studio (VS) plug-in it is a requirement that Visual Studio 2019 is installed on the PC prior to installing Dimodelo Data Warehouse Modeler. Dimodelo Data Warehouse Modeler will download and install the VS 2019 Shell version if VS 2019 is not present on the PC. However, Dimodelo is compatible with any version of VS 2019 including Community, Professional and Enterprise. If one of these is present, Dimodelo Data Warehouse Modeler is installed in “integrated mode”. This means you simply see a new kind of project template (Dimodelo Solutions) when creating new projects.

Note: Visual Studio is available for free through the Microsoft Visual Studio essentials program for eligible users. We have more on Visual studio licencing for BI developers.

** Note, these instructions were written for the Dimodelo Data Warehouse Studio product, however, the process is exactly the same **

Get a copy of “Dimodelo Data Warehouse Modeler”

To download Dimodelo Data Warehouse Modeler Community edition visit the product page and scroll down to the download button.

To get the professional version of Dimodelo Data Warehouse Modeler, please contact sales to discuss licencing.

Install “Dimodelo Data Warehouse Modeler”

1. Double click on DimodeloModeler.exe. The following window will appear. Tick to agree to the terms and conditions, and then Click Install.

2. The Dimodelo Management Console installer window appears. Dimodelo Management console is a small .NET app that is used to run and orchestrate ETL batch runs. It’s the same software you would install on a test or Production server to run and monitor batches. On the window that appears, Click Next.

3. Select Everyone, then Click Next.

4. Click Next on the confirmation dialog.

5. Click Close.

After the Dimodelo management Console is installed, the Dimodelo Data Warehouse Modeler installer window appears.

6. Click Next.

7. Choose where you want to install the software. Typically in the default folder. Dimodelo Data Warehouse Modeler is a 32-bit application because VS is a 32-bit application. Dimodelo Management Console is a 64-bit application, therefore ETL batches run as 64 bit. Click Next.

8. Click Install.

9. Wait for the install to finish. It can take a couple of minutes, with nothing apparently happening.

10. If more that one local instance of SQL Server is present on the PC, the installer discovers the local instances of SQL Server and asks you to nominate one as the default Server for development. If you are targeting SQL Server on-premise, New projects are created with a configuration that targets the selected server. This can be changed on a project by project basis later.

11. Once complete, Click Finish.

12. Click Close.

Uninstall “Dimodelo Data Warehouse Modeler for Azure”

At a later time, if you need to uninstall Dimodelo Data Warehouse Modeler, you can do so through the Control Panel>Uninstall a Program option.

1. Open Control Panel and select Uninstall a Program.

1. 2. Select “Dimodelo Management Console” and Right Click>Uninstall.

3. After the previous step completes select “Dimodelo Data Warehouse Modeler“ (not shown) and Right Click>Uninstall.