Cassandra OLEDB Provider v1.4 for 32 and 64-bit Applications.
The OLEDB provider for Apache Cassandra features a rich set of
interfaces and metadata along with fast and asynchronous operations. It
uses CQL3 and v1.2 binary protocol for most underlying operations, and
for some operations like the bulk data loading – it uses thrift.
The OLEDB provider offers one of the most versatile and powerful
metadata. The following OLEDB schemas are available: TABLES, VIEWS,
COLUMNS, INDEXES, PROVIDER_TYPES, SCHEMATA, PRIMARY_KEYS, FOREIGN_KEYS, etc.
The OLEDB provider supports connect timeout, pooling, SSL, and multiple connections to the Cassandra ring.
Bulk insert and FastLoad
It supports both the “regular” and the “fast” bulk loading of data into Cassandra.
Since Cassandra does not support transactions, the provider uses BEGIN
BATCH when StartTransaction is called, and APPLY BATCH when Commit is
called. Aborting a transaction results in cancelling all commands
between StartTransaction and Abort.
The OLEDB provider supports command-prepare, command-cancel, and
parameters conversion. The parameters conversion allows an application
to pass parameters of types that are different from what CQL expects,
and the provider will automatically convert the parameters to what
Cassandra expects. Multiple parameter sets and named parameters are not
Multiple result sets
The OLEDB provider supports execution of multiple semicolon separated statements.
Collection types support
The list, map and set columns can be queryed, altered and deleted via
the provider. Detailed examples are available for C# and C++.
CQLSH commands support
The OLEDB provider recognizes and handles CQLSH commands such as DESCRIBE and COPY.
The OLEDB provider supports asynchronous connect and records querying by
exposing IDBAsynchStatus and ISSAsynchStatus interfaces.
Integration with Microsoft BI tools and other popular applications
The provider integrates well with BI Tools(SSIS, SSAS, SSRS),
Office(Excel, Visio), and other popular applications and platforms
(Crystal Reports, QlikView, etc.)
Tracing and profiling
The tracing and profiling application allows collecting and storing
information about all statements executed via the OLEDB provider.
Automated product updates
The PGNP Updater utility is included for the automated product updates.
Supported OS Platforms
Windows 2000, Windows XP, Windows Server 2003, Windows Server 2008 R2, Windows Vista, Windows 7, Windows 8
Windows installation module with samples is included in the product. To uninstall the provider run the uninstall utility. For Trial Version, examples and documentation see our web site: www.intellisoftica.com.
Single license allows installation on one computer in the organization.