Page 1 of 1
Pervasive PSQL
Posted: Tue May 18, 2010 4:58 pm
by jkknind
I have a business software that uses PSQL (Pervasive).
Can I use DigitalClay to extract from
and extend the range of data, in real time
for creating dashboards, custom reports?
Thanks.
JK
Re: Pervasive PSQL
Posted: Thu May 20, 2010 1:00 pm
by ZevToledano
Digital-Clay is not a front-end for other systems/databases - it is its own system with integration capabilities. However, you can extract data from Pervasive using either the ClayIntegrator on a schedule via an ODBC connection, or using
Data Injection. Using Data Injection, you may be able to achieve close to real-time updates from the Pervasive DB to Clay's DB, depending on how you implement it (i.e. you will probably need db triggers).
Once the data is integrated, you can easily modify it using automations, and create reports/dashboards etc.