Database connections

Since the TARGIT Server is the middle tier between end-users and your Data Warehouse, you will also need to configure which databases it should connect to.

Click the Connections icon. This is where we define which database(s) we would like the TARGIT Server to connect to.

At first, we notice that multiple database connections have already been defined:

• GIS. GIS is for Geographical Information Systems. If your TARGIT solution includes scalable maps, based on GIS information, you must use this entry to map GIS information to dimension values.
• DemoData. This connection provides access to the standard Demo Data (if they were installed). It is also necessary for opening the Demo analyses, dashboards and report.

But now we would like to add a new connection. Right click somewhere in the blank area and select Add.

The Database Connection wizard appears. Select e.g. the Multi-Dimensional Database option.

Choose database provider. E.g., select the Microsoft Analysis Services 2016 option.

Name the connection e.g. Training and click Next.

Next, you have to define the server and database to be used.

Click Next to define additional properties. Accept the default settings

We have now defined the Connection Type, the Provider and the Connection which is what is needed to make the TARGIT Server use this data source.

Click Create.

Let’s take a look at our database connections. Notice that we now have four real database connections.

In the following lessons we will only use data from the Training connection, the connection to our newly designed OLAP database. To avoid confusion later in this course we will disable the DemoData connection