416.467.9100 | Dundas Data Visualization | Login
Welcome Guest

This site makes extensive use of JavaScript.

Please enable JavaScript in your web browser and reload the page before proceeding.

Odbc DB2 and PostgreSQL Data Provider sample project

Hide navigation
RSS
Modified on Wed, 25 Aug 2010 11:46 PM Categorized as Data, Data Connectors, How-to

Overview

This sample should demonstrate how to create a Data provider using ODBC for Dundas Dashboard and allowing Dundas Dashboard to connect to IBM DB2 9.7 and PostgreSQL 8.4.

Sample Requirements

In order to compile the code you will need .net framework 3.5 or Higher.

The project is created under Visual Studio 2008, so in order to open up the solution or project file you will need to have Visual Studio 2008 or greater.

Dundas Dashboard Version 2.

PostgreSQL 8.4

IBM DB2 9.7

Compiling and building a Data Provider (server side) plug-in package

step 1

Download the attachment in this article. The attachment is link is found in the upper right hand corner.

step 2

Unzip the file and open up the solution file.

step 3

Compile the project. This will create a bin file in the directory for this project and depending on the compiling configuration set it will either create a debug or release folder under the bin directory.

step 4

Open up the Dundas Dashboard plug in packager, to do that go to your start menu > all programs > Dundas Data Visualization Inc > Dundas Dashboard V2.0.0 > Tools > Plugin packager

step 5

Once the Dundas Dashboard plug in packager is open up, in the general tab select DataProviderServer in the type drop down list and click on the create link to generate a plug in id. Than you can fill in the rest of the information as you like. Click on the files tab and click on add option and this should open up a file dialog, now navigate to the bin folder that is created in step 3 and this should have either a debug folder and a release folder depending on the configuration that is set for compiling. Under those folder it should be have a Dundas.Dashboard.OdbcProvider.dll, double click on that and it should add that dll into the list view in that general tab.

step 6

hit the save option and name the plugin file what ever you want.

Installing the odbc data provider plug in

step 1

Download the attachment in this article. The attachment is link is found in the upper right hand corner.

step 2

Please open up the Dundas Dashboard Plugin manager, to do that go to your start menu > all programs > Dundas Data Visualization Inc > Dundas Dashboard V2.0.0 > Tools > Plugin Manager.

step 3

In the plugin manager please select a application folder which is the directory app data folder found in the dundas dashboard website folder. Here is a sample path C:\Program Files\Dundas Data Visualization Inc\Dundas Dashboard\2.0.0\www\App_Data. This path can be different depending on what folder you have set Dundas Dashboard to be installed in.

step 4

click on the install option and this should pop up a file dialog where you can navigate and select the plug in file you want. If you have follow all the step in the "Compiling and building a Data Provider (server side) plug-in package" section of this article you can navigate and select the plug in that was created there. If not you can simply navigate to the plugin folder that is found in this attachment and select the plugin file that is found there.

step 5

Restart IIS and navigate to Dundas Dashboard as usual.

step 6

Create a new data connector and you should be able to see two new data options, DB2 and PostgreSQL.

Limitations of this Sample

DB2

Data structure currently only supports tables and views.

supports the following data types

BIGINT, CHARACTER, DATE, TIMESTAMP, DECIMAL, DOUBLE, INTEGER, REAL, SMALLINT, LONG VARCHAR, TIME, VARCHAR

PostgreSQL

Data structure currently only supports tables and views.

supports the following data types

bigint, boolean, character, char, date, timestamp without time zone, double precision, money, integer, numeric, real, smallint, text, time without time zone, uuid, character varying

Downloads

About Dundas | Contact Us Follow us on Twitter! | Privacy Statement | Report Site Issues

Copyright © 2009-2012 Dundas Data Visualization, Inc.