Help connecting to a pervasive database

Five Stars

Help connecting to a pervasive database

NewBie here!

I need some help setting up a connection to a pervasive database, I have an ODBC connection setup, but I don't see a option for odbc under the DB Type. So how do you create a connect to a pervasive database? Any help would be greatly appreciated!

Tags (1)
Forteen Stars

Re: Help connecting to a pervasive database

Hi 

 

Talend Studio is Java application and does not work with ODBC, instead, you need use JDBC drivers

you need check Pervasive site for download proper jdbc drivers and manually setup JDBC connection in Talend

 

sample of connection properties would be similar to - https://www.dbvis.com/features/pervasive-database-drivers/

 

-----------
Five Stars

Re: Help connecting to a pervasive database

Thanks for the reply!

I search the web and could not find a jdbc driver for pervasive, can anyone point me to a url where I can download jdbc drivers for pervasive database?

Forteen Stars

Re: Help connecting to a pervasive database

Google + DbSchema will help you :-)

 

https://www.dbschema.com/jdbc-drivers/PervasiveJdbcDriver.zip

-----------
Five Stars

Re: Help connecting to a pervasive database

Hey vapukov,

Thanks For the zip files,  I'm having a problem getting the pvjdbc2.jar file installed.  I think I'm doing this right, I went under "Show views" then selected Modules, and then selected the import external jars, found my file. I can see it installed in the list of modules, but as soon as I refresh the install goes away, looks like talend is not saving the install file.  I'm using Talend v7.1 any ideas?

Thanks again for your help.

Community Manager

Re: Help connecting to a pervasive database

Hi Pager
Use tJDBCxxx component and specify the jar file in the Drivers table.

Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Help connecting to a pervasive database

Hi,

 

I have DBVIS installed and the connection is working fine.   However when I try to access the data via Talend, I'm unable to do so.

Here the steps I followed:

 

via modules, installed 2 jars, needed for the database connection (identical ones to the ones used in DBVIS)

 

When I add in the database connection, the Pervasive driver is not showing up, which is strange ( but not an issue, seems to me)

 

I just add in the pervasive connection as a basic JDBC connection, similar to the syntax used on the DBVIS...

And I add in the drivers manually as shown in the below screenshot.  No username and password are required in DBVIS, but still not working.

 

Screenshot 2019-06-28 at 11.27.27.jpg

 

The error is connection failure. You must change the database setting, but which setting do I need to change?

In the detail it states:

Connection failure. You must change the Database Settings.
java.lang.reflect.InvocationTargetException
..
Caused by: java.lang.ClassNotFoundException: com.pervasive.pscs.Manager
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 24 more

 

Can someone help me out, please?

 

Thanks in advance.

Five Stars

Re: Help connecting to a pervasive database

This is how I have my pervasive db connection setup. Hope this helps.connection.JPG

Four Stars

Re: Help connecting to a pervasive database

Hi,

 

thanks for your help.  It seems that I missed a component, which isn't needed for dbvisualizer.

 

My connection is now successful on testing, but on saving (finish) I get following error:

 

Screenshot 2019-07-01 at 08.44.35.jpg

What am I doing wrong?

Four Stars

Re: Help connecting to a pervasive database

It seems that there was a stability issue on saving the connection.  I retried and now it saves seemingly correctly.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog