# JDBC driver for Progress 9.1E **URL:** \ **Category:** Archived Topics\ **Created:** [September 28, 2011, 8:43pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362 "2011-09-28T20:43:42Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ecujak](https://avatars.discourse-cdn.com/v4/letter/e/839c29/32.png) [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Post date:** [September 28, 2011, 8:43pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/1 "2011-09-28T20:43:42Z")
I am hoping to be able to connect to Progress 9.1E database. Help/// ---
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [September 28, 2011, 9:03pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/2 "2011-09-28T21:03:13Z")
If I’m not mistaken on the media provided with Progress there is a set of “client components” including a driver that will operate with JDBC. ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [September 29, 2011, 1:11am UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/3 "2011-09-29T01:11:31Z")
Generally, with JDBC available, we can get it to work with the system. Sometimes there are some intricacies that make things difficult, but hopefully we can work around those. Unfortunately, none of us here have any experience with that system, so we can’t help too much off the bat, but we can help with the process. Conveniently, I found a pretty good user’s guide for the jdbc driver [here](http://communities.progress.com/pcom/docs/DOC-4098). The basic process: 1. Create a new database translator from System\>Database\>Drivers\>Translators Tab. 2. Create a new driver entry 2b) Add the jar file(s) 2c) Configure the settings: Class name: [tt]com.progress.sql.jdbc.JdbcProgressDriver[/tt] Url Format: [tt]jdbc:JdbcProgress:T:isis:5000:testdb[/tt] DB Translator: As created above 3. Create a new connection using that driver 4. Try to figure out what to tweak to make it work! I got these values from the guide, hopefully they’re correct. Obviously, the trickiest part is #4. Each database has a variety of quirks- from a decent validation query (a query that can be run to make sure the connection is ok, that returns 1 value), to the specific syntax for creating tables, indexes, id columns, etc. Depending on what you want to do you may not have to get into all of that. If you just want to read data, for example, you may just need to get the validation query to work (and there’s a good chance that the default “select 1” is fine). If you want to use all features, including transaction groups and sqltags (external, or sqltags history), you might have a bit more work on your hands. Hope this gets you started, ---
**Author:** ![ecujak](https://avatars.discourse-cdn.com/v4/letter/e/839c29/32.png) [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Post date:** [September 29, 2011, 12:38pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/4 "2011-09-29T12:38:37Z")
Thank you both. I will work on this. ---
**Author:** ![ecujak](https://avatars.discourse-cdn.com/v4/letter/e/839c29/32.png) [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\ **Post date:** [March 12, 2012, 9:01pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/5 "2012-03-12T21:01:56Z")
> [@](#): > > Url Format: jdbc:JdbcProgress:T:isis:5000:testdb It seems you may be an Archer fan... I am having trouble in Data Type Mapping section. What is this page asking for? ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/274bea26770bfa191467f88692d2fdd3ed923906.jpg) Do any of these keywords go in the fields above? ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/5cb3f57ebe48206e58b1aee18cf971caf949c9c7.jpg) ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/4d35e4924f89c7909d63b110b0a91f35a109ca45.jpg) ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e88bbac71be0d22e1b3d47ef90b159cde6d75d70.jpg) ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [March 12, 2012, 11:48pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/6 "2012-03-12T23:48:31Z")
> [@](#): > > It seems you may be an Archer fan... I actually just copied that directly from something I found online... so any clever references are (unfortunately) not my responsibility! 😆 So, that table is mapping our types to the database types. You can pretty much pull them directly from that first table you posted. We tend to just use "integer" for the main integer number types, but you can try using the more specific types. So, it looks like you would use the following: I1=TINYINT I2=SMALLINT I4=INTEGER I8=INTEGER? Maybe NUMERIC Boolean=BIT Datetime=TIMESTAMP R4=REAL R8=DOUBLE String=VARCHAR Binary=LONGVARBINARY Hope this helps, ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 12, 2012, 11:58pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/7 "2012-03-12T23:58:03Z")
Perhaps I don’t understand what’s going on here… …but I have a connection to Postgres 9.1 on my dev machine and I did zero configuration work other than making sure the username, password, and database name were specified. What are you guys doing? ---
**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Post date:** [March 13, 2012, 4:14am UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/8 "2012-03-13T04:14:18Z")
[quote=“Kevin.Herron”]Perhaps I don’t understand what’s going on here… …but I have a connection to Postgres 9.1 on my dev machine and I did zero configuration work other than making sure the username, password, and database name were specified. What are you guys doing?[/quote] er… Progress 9.1E? ---
**Author:** ![aidamcg](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\ **Post date:** [March 13, 2012, 7:31am UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/9 "2012-03-13T07:31:48Z")
Hi This topic explains connecting to a 10.1.C progress DB. Might be of some help Aidan [http://inductiveautomation.com/forum/viewtopic.php?f=54&t=7677&p=23736&hilit=progress#p23736](http://inductiveautomation.com/forum/viewtopic.php?f=54&t=7677&p=23736&hilit=progress#p23736) ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 13, 2012, 2:31pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-for-progress-9-1e/3362/10 "2012-03-13T14:31:32Z")
Oh wow, I see my problem… 😊 You guys are talking about “Progress”, not “Postgres”. Durrrrrh. 😊