SnowFlake JDBC Connection

[rnunezcarecloud.com]

I am trying to conncect to SnowFlake Cloud DataWarehouse (https://www.snowflake.net/).  SnowFlake offer a JDBC connector, which I am trying to install.  

I am using Jaspersoft Version 6 and I try to add the JDBC connection by doing the following:

From the root tree, I choose jdbc ->add resource->file->jar.   The jdbc driver was uploaded succesfully and it shows in the repository.

From the data sources, i choose add resource->data source, choose type:jdbc Data Source, when choosing the jdbc driver from the list, the SnowFlake driver

doesn't show at all.   The default driver is PostgreSQL (org.postgresql.driver).  if you click the "Select Driver" button to the righrt it just try to overwrite the listed driver.

[rnunezcarecloud.com]

Is there anyone in this users group that have succesfully connected to the SnowFlake Cloud Data Warehouse?

[hozawa]

Did you try adding the jdbc driver by selecting "Data Source" instead of "Resource"? See "To add a JDBC driver" in the following page.

https://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v561/managing-jdbc-drivers

[rnunezcarecloud.com]

Hi Hozawa

I did try to add the new connection via "New Data Source" .  This area list all allowed data source with "Installed" or "Not Install" jdbc driver configurations.  SnowFlake is not listed, there.   If you click on the Driver to uplload it into the Jasper environment, it will just replace the listed configuration..

That's the reason I added the jdbc resource first and then try to find it in the list of connections.

[hozawa]

Just type in the jdbc url in the text box.

[Scott Andersen]

To add a new driver you need to click on "Other", start to enter the driver name in the driver name field and the "Add Driver " button is enabl;ed.  You can then add the driver This adds a new entry in in the list of JDBC drivers.

[lisaws]

I am having this problem as well.  When I click on "Other" and start to type the driver name, I don't see an "Add Driver" button anywhere.  Where can I upload my jar?

[Scott Andersen]

To add drivers you need to be logged in as superuser.