Skip to main content
Version: 4.3.0

Data Source Connection

Article Date

When you delve into dReveal's desktop builders, your first task will involve configuring data source connections. This step is crucial for establishing a seamless link to your data, facilitating a smooth reporting process. Whether you are opening an existing grid report or creating a new one, you will be prompted to specify a data source connection.

dReveal allows users to access and analyze data from multiple providers, such as:

Database Management Systems Connections:

  • Microsoft SQL Server
  • MySQL
  • PostgreSQL

Data Access Protocols:

  • oData

Creating a Connection:

You'll build a new connection by providing the following details:

Database Management Systems Connections

Field NameInstructions
Connection NameGive your connection a descriptive name to easily recognize it later.
Data Source TypeSelect the type of connection.
Server NameInput the server's name where your data resides.
Port NumberSpecify the port number for establishing the connection.
CredentialsProvide the necessary login credentials to ensure secure access (Note: Microsoft SQL Server has the option to 'Use Windows Authentication').
Database NameSpecify the database name.

After entering these values, you can test the connection to verify its functionality. Once you're satisfied, simply click "OK." Congratulations, you've successfully created your first connection string!

Data Access Protocols

Field NameInstructions
Connection NameGive your connection a descriptive name to easily recognize it later.
Data Source TypeSelect the type of connection.
URLSpecify the URL of the OData service.
CredentialsProvide the necessary login credentials to ensure secure access.
AnonymousCheck this option to access the resources without requiring credentials.

After entering these values, you can test the connection to verify its functionality. Once you're satisfied, simply click "OK." Congratulations, you've successfully created your first connection string!

Managing Connections:

But that's not all! dReveal allows you to manage your connections effortlessly. You can:

  • Create multiple connections tailored to different data sources.
  • Modify existing connections to update details if necessary.
  • Remove connections that are no longer needed.

What's even more convenient is that these connections are available across all designers, including Model, Grid, and Dashboard. Simply select the desired connection from your list, and dive into building your reports, whether it's a grid, dashboard, or model.

Within the Grid Designer, you have the flexibility to modify or establish new connections using the label 'Connections' found in the main menu. These options are essential for managing the data sources and connections vital to your reporting tasks.