Database Drivers to Use with Quantrix

5.10K viewsDataLink
0

Hello Forum Community,

Many of you have asked which specific drivers can be used when using Quantrix DataLink to connect to outside data sources. Since Quantrix is a Java application, it is best to use Java based JDBC drivers when possible.

Here is a list of database drivers we have successfully used internally. For JDBC drivers, you can install the jar file via [b:um6j6yp0]Tools > Options > Database (JDBC)[/b:um6j6yp0]. Most ODBC drivers have an installation program that can be run to set up the driver.

[b:um6j6yp0][u:um6j6yp0]MySQL[/u:um6j6yp0][/b:um6j6yp0] – MySQL Connect J 5.0 which can be found at this URL:

[url:um6j6yp0]http://dev.mysql.com/downloads/connector/j/5.0.html[/url:um6j6yp0]

[b:um6j6yp0][u:um6j6yp0]Oracle[/u:um6j6yp0][/b:um6j6yp0] – Oracle provides JDBC drivers which can be found at this URL:

[url:um6j6yp0]http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html[/url:um6j6yp0]

[b:um6j6yp0][u:um6j6yp0]SQL Server & Sybase[/u:um6j6yp0][/b:um6j6yp0] – JTDS is a free open source JDBC driver that can be used to connect to these Databases. You can find the JTDS driver at this URL:

[url:um6j6yp0]http://jtds.sourceforge.net/[/url:um6j6yp0]

[b:um6j6yp0][u:um6j6yp0]Quickbooks[/u:um6j6yp0][/b:um6j6yp0] – QODBC offers a ODBC driver for sale that connects with Quickbooks. More information on this driver can be found at this URL:

[url:um6j6yp0]http://www.qodbc.com[/url:um6j6yp0]

[b:um6j6yp0][u:um6j6yp0]Text Files[/u:um6j6yp0][/b:um6j6yp0] – The windows operating system has an ODBC driver that allows Quantrix to connect to a directory of .csv text files. This driver is not installed by default but can be installed via:

[b:um6j6yp0]Control Panel > Administrative Tools > ODBC Data Sources[/b:um6j6yp0].

[b:um6j6yp0][u:um6j6yp0]MYOB[/u:um6j6yp0][/b:um6j6yp0] – The MYOB installation comes with an ODBC driver. After installing MYOB, this driver can be added to your system via:

[b:um6j6yp0]Start > Programs > MYOB Premier 9 > MYOB Tools > MYOB ODBC[/b:um6j6yp0]

If anyone else in the forum community has successfully used a JDBC or ODBC driver to connect to a database, please feel free to post the information in this thread.

0

Thanks for the update John. Most appreciated.

0

Surely there is more current information about the best Oracle JDBC drivers two and a half years later? I successfully used the OJDBC7.jar driver file available on Oracle.com.

0

Hi James I have quantrix 4 running on win 7 64 bit no issues.

Mike Locascio here

0

I have been unable to get jTDS to work with Quantrix 4.0 installed on a 64-bit machine. I continue to get the error about SSPI context / SSO, even though I have put the dll’s into the system directories.

0

[quote="EricN":18tdgwey]Can Quantrix use the native database drivers for either MS SQL Server or Oracle?[/quote:18tdgwey]

Hi – Typically these drivers require DLL’s to run which means they cannot be loaded into Quantrix’s JDBC driver registry easily. They would need to be bundled into a plugin for them to work correctly in Quantrix.

However, with these two databases we have had very good success with JTDS for SQL Server and the Thin JDBC driver for Oracle as outlined in this post.

0

Can Quantrix use the native database drivers for either MS SQL Server or Oracle?

0

What about csv on Mac?? All documentation suggests this is part of Standard Edition but I can’t find a way to access CSV files!

0

Just a note on the subject, we had been using the standard ODBC driver to connect to SQL Server from Quantrix. When we switched to the JTDS driver, the performance improved by 2-3 times.

The JTDS driver is easy to set up. I’ve tried the Microsoft JDBC driver but you have to move a .dll around to get it to work with integrated security, which is a bit of a pain. The instructions on Microsoft’s site aren’t very clear and I haven’t got it to work just yet. Performance-wise, it compares to JTDS for non-integrated security queries.

0

No specific reason I can think of. We have had good success with the JTDS driver so we tend to stick with that one. Please feel free to post any experiences you have with the Micorsoft JDBC driver.

0

In a previous post, you listed both the jTDS and the Microsoft JDBC drivers. Is there a reason you no longer list the Microsoft driver?

0

Thanks….