How to Connect Tableau to a Progress OpenEdge Database

Connecting Tableau to a Progress OpenEdge database allows you to easily extract and analyze your data in various formats, such as reports, dashboards, and visualizations. This article will walk you through the process of setting up the connection and establishing a data source.

Step 1: Select the Default Data Source Name

To begin, select the default data source name at the top of the page and enter a unique data source name for use in Tableau. This will help you keep track of your connections and ensure that you are connecting to the correct database.

Troubleshooting Connection Issues

If you still cannot connect to your Progress OpenEdge database, it is likely that there is an issue with locating the server or verifying credentials. In this case, check that your computer can locate the server and verify that your credentials are correct.

Running Initial SQL Statements

(Optional) If you want to run a specific SQL command at the beginning of every connection, select the 'Initial SQL' option in Tableau's data source page. This can be useful for setting up default parameters or executing any necessary setup scripts before connecting to the database.

Specifying the Server Name

Enter the name of the server that hosts your Progress OpenEdge database. You can find a complete list of available data connections by selecting 'More' under 'To a Server' in Tableau's connection dialog box.

Connecting and Setting Up the Data Source

To connect to your Progress OpenEdge database, start Tableau and select 'Progress OpenEdge' from the 'Connect' menu. Make sure that you have the required driver installed on your computer, as this connector requires a driver to communicate with the database. If the driver is not installed, you will see a message in the connection dialog box with a link to download and install the necessary software.

Using the Connector

The Progress OpenEdge connector is compatible with Tableau Desktop on Windows computers only. Once you have set up your data source, you can use Tableau's drag-and-drop interface to connect to your database, create visualizations, and share insights with others.

By following these steps, you should be able to successfully connect Tableau to your Progress OpenEdge database and start analyzing your data in no time.

Progress openedge driver