SQL Database Access connects any ds9 solution to the full set of commercial databases supporting JDBC.
ds9 solutions now read data from internal or external databases to merge retrieved data with data extracted from the web or
they automatically retrieve and extract data from the web to enrich or update internal data sources.
More and more are data analysts and business intelligence experts relying not only on internal numbers but need to add external data to bring the
intelligence to the level that is needed to make competent decisions.
ds9 SQL Database Access is the connector between internal data and external content.
Connect to any JDBC Datasource
Commercial and free JDBC drivers provide connectivity to most relational-database servers available on the market. All major vendors of RDBMS provide JDBC drivers for their databases opening the whole world of
corporate databases to ds9 solutions.
Reading JDBC Data
JDBC reading access allows to access any JDBC compatible database. SQL queries can be written using the full language set of the connected RDBMS.
Statements can be customized by using %LABEL%s that correspond with datafield names of the provided input. Thus multiple records in the input will trigger different SQL requests against the database.
Maintaining Entity Relationships When Writing JDBC Data
Even though the model of ds9 user data is not relational, connected relational databases can be filled with relational data across multiple database tables by ensuring relational integrity through the ds9 filter chains.
Thus crawling data from different sources in the Internet and writing extracted data to multiple tables that depend on each other through foreign key relationships is a common task for the JDBC connector.
Since ds9 is mostly operated on Deep SEARCH 9 hosted servers to preserve bandwidth of the corporate network and to hide search activity from the public, ds9 supports
transfer of JDBC data through encrypted channels and authentication using certificates. There are multiple ways to ensure data security going as far as installing a
ds9 instance in the corporate LAN that synchronizes containers before data is read from or written to corporate databases.