Using JDBC under Mac OS X

5.78K viewsDataLink
0

Hello,

I’m looking for information on how to make Quantrix DataLink through JDBC work on Mac OS X – specifically, I’m interested in connecting to Excel / MySQL.

Does anybody have any suggestions / links?

Best,
Victor

0

Has anyone been able to get this to work?

I’m looking for a way to link my excel spreadsheets to Quantrix under OSX.

Is there any easy way to do this?

Thank you,
Stefan

0

[quote="geneos":1t7le0g3]I am in urgent need of JDBC driver for Excel in a MAC…. Please help me!!!![/quote:1t7le0g3]

I am not sure whether this is what you are looking for. And it is not for free: US$ 330:
[url:1t7le0g3]http://www.hxtt.com/excel.html[/url:1t7le0g3]

Dominik

0

I have researched JDBC options for Excel / Access recently and there still is not many good alternatives for JDBC. You may want to investigate saving your excel source as a text csv file and using the csv importer instead. Sorry I am not of more help.

If anyone else in the Quantrix community has had a more successful experience with JDBC / Excel, please feel free to post.

-Mike

0

I am in urgent need of JDBC driver for Excel in a MAC…. Please help me!!!!

0

For Windows Users – Quantrix comes with a built-in ODBC driver for Excel. Here are the steps:

1. In your excel file, you need to ‘name the ranges’ of data. To do this, select the data and then choose [b:1vmvivmx]Insert > Name > Define[/b:1vmvivmx] and name the range.

2. In Quantrix, choose [b:1vmvivmx]Tools > DataLink > Create DataLink[/b:1vmvivmx] from the menu. Select the [b:1vmvivmx]JDBC / ODBC Data Source[/b:1vmvivmx] and click [b:1vmvivmx]Next[/b:1vmvivmx]. For the driver select [b:1vmvivmx]ODBC Database Connection[/b:1vmvivmx] and for the URL Type choose [b:1vmvivmx]Microsoft Excel File[/b:1vmvivmx] and then click the [b:1vmvivmx]Browse[/b:1vmvivmx] button to select the Excel file you want to work with.

At this point when you click Next, the ranges you have named will show up as Tables in the left hand side of the DataLink wizard. If you need more help on the import process into Quantrix, you can review the QuickGuide tutorial on DataLink here:

[url:1vmvivmx]http://www.quantrix.com/r-doc-4-18-104[/url:1vmvivmx]

-Mike

0

Andy / Mike – thanks for your suggestions. Will watch for an Excel solution.

0

Victor/Mike

We have not had much luck trying to use JDBC to connect to Excel. Thanks to Quantrix for addressing the “exceptions” error being generated in the most recent update but still no connection. We have had a few people looking at this issue and through lots of “trial and error” I think we are getting close! I will keep you informed as we continue working on this issue during the upcoming week.

Andy

0

Hi – Thanks for the post. I have used the JDBC driver for MYSQL successfully with Quantrix. You can find this driver here:

[url:1fpiamxq]http://www.mysql.com/products/connector/j/[/url:1fpiamxq]

I have a contact who has tried an JDBC version of an Excel driver. I will see if this person can post their experiences here.

More information on how to actually use DataLink can be found here:

[url:1fpiamxq]http://www.quantrix.com/r-doc-4-18-104[/url:1fpiamxq]

-Mike