Databases Reference
In-Depth Information
Another common example of a custom data source, which has been increasingly
used in QlikView deployments, is the SAP platform. At an additional license fee,
QlikTech provides a set of
.dll
-based QlikView connectors which you can use to
access SAP data (R/3, mySAP, and BW). This connector is SAP-certified, and comes
with built-in wizards to query the database and even includes prebuilt QlikView
applications, which will literally help you build the script you need to extract any
required table. It's especially useful when you don't know how tables are related,
or don't actually know the technical names of the fields in a table, which is also
very common.
Third-party custom connectors
As stated previously, we can build our own custom connectors. In the case of the
data source being
Salesforce.com
or SAP, you can opt to use the ones QlikTech
offers. There are also third-party companies who specialize in providing this kind
of connectivity for other common, custom data types. Two examples of third-party
custom connectors are:
•
QVSource
: This connector, built by Industrial CodeBox, can be used to
extract data from a large number of web services that are accessible via
APIs. You can easily load data from social media sites, such as Facebook
or Twitter, and business web apps, such as Google Analytics, Google
Spreadsheets, and so on.
° More information about QVSource can be found at
http://www.qvsource.com
.
•
QlikView JDBC connector
: This connector, from TIQ Solutions, enables
the possibility of communicating with
Java Database Connectivity
(JDBC)
data sources from QlikView. JDBC is an industry standard for
database-independent connectivity for a wide range of data sources.
Common examples are the Java-based databases such as Derby, or Big Data
environments such as Hadoop Hive.
° More information about the JDBC connector can be found at
http://www.tiq-solutions.de/display/enghome
.
