you can see this post
http://community.qlik.com/docs/DOC-2438#comment-6711
here said that
This is the new list of actual working JDBC data sources for QlikView:
- Hadoop HDFS and Hive
(Cloudera, MapR, Amazon EMR) - Cloudera Impala (via Beeswax API)
- SAP HANA
- SAP ERP/BW (via SAP JCo)
- Kx Systems KDB+
- Microsoft Windows SQL Azure
- Google Cloud SQL
- Neo4j Graph Database
- Apache Derby / Java DB
- encrypted CSV files
- COBOL files
- Pentaho Kettle Transformation Steps
For the most of them no alternative connectivity solution is provided for QlikView.
- Ralf
and then....
Hi Ralf,
I am working on QlikView version 11 SR2 and a 32 bit machine.
I downloaded JDBC Connector via this link.
http://www.tiq-solutions.de/display/enghome/ENJDBC
I have Oracle 11g Release 2 and I used the following jar file.
C:\app\Administrator\product\11.2.0\client_1\jdbc\lib\ojdbc6.jar
Java path is C:\Program Files\Java\jre1.6.0_01\bin.
In QlikView, JDBC screen, typed the URL as,
jdbc:oracle:thin:@IPAddress:1521:SID
And I typed user name and password also.
But, the message shows "No suitable driver found for "jdbc:oracle:thin:@IPAddress:1521:SID".
I see this message via http://market.qlik.com/qlikview-jdbc-connector.html,
Possible JDBC data sources:
- Derby / Java DB
- encrypted CSV files
- Hadoop Hive
- Neo4j Graph Database
- Microsoft Windows SQL Azure
- COBOL files
- FoxPro / DBF files
I can't connect with Oracle?
With regards,
Hnin
hope that helps you
