SourcePro DB Enables You to Deploy With Any Database

SourcePro DB is an add-on SourcePro. It enables you to deploy with any database.

SourcePro DB offers a layered architecture consisting of the database-independent interface module and a variety of database-specific access modules.

This architecture allows developers to write programs that are reusable with multiple databases. It also frees them from needing to understand many of the details associated with a particular database vendor’s API.

Using SourcePro DB expands SourcePro Core. You can scale SourcePro DB to meet your needs and improve the performance of your application. You can also add SourcePro Net and SourcePro Analysis.

Build Once, Deploy With Any Database

SourcePro DB provides an object-oriented interface that abstracts away the complexity of writing database applications. And it allows developers to drill down to the native database client libraries if needed.

You can use SourcePro to access many databases, including Oracle, Microsoft SQL Server, DB2, MySQL, Sybase, MariaDB, and PostgreSQL databases. You can also use an ODBC driver for other databases like Informix.

Because developers only need to learn a single interface, you can build once and deploy everywhere. SourcePro DB provides a consistent object-oriented API across all supported vendor databases.

Minimize Maintenance

SourcePro DB adapts each database module to take advantage of the new features and improvements provided by the latest releases. At the same time, SourcePro shields your applications from eventual compatibility issues.

Each new release of SourcePro brings support for the latest operating systems available as well as database versions and updates. This minimizes maintenance as you build your applications.

Plus, you’ll get increased security. SourcePro DB conforms to the latest security standards, including CWE, CERT, OWASP, DISA STIG, and MISRA.

Maximize Performance

SourcePro DB also maximizes performance in three ways.

First, developers whose database metadata doesn't change frequently can activate a result-set schema and metadata caching (schemas, keys, and constraints).

Next, SourcePro uses the latest improvements from C++ standards, compilers, databases, and operating systems to optimize the various database modules.

Finally, SourcePro DB's OpenSQL API helps developers maximize performance on a specific database. It provides lower-level access via a statement-based architecture. This allows developers to create their own SQL, bind the variables to the statement, and execute the statement.

Handle Large Data Sets

Big data and fast processing are the challenges of today and SourcePro DB is more than up to it.

SourcePro DB supports key cloud providers such as SQL Azure and Oracle. As a result, SourcePro DB connects seamlessly to cloud-based data and elastic-scale tools to solve your big relational data set needs.

Key Features in SourcePro DB

SourcePro DB provides the following database connectivity features for building your C++ applications.

Features	Benefits
Consistent, object-oriented programming interface to multiple back-end databases.	Encapsulates leading relational database vendors' APIs. This is universal for all applications regardless of which database is used. Frees developers from dealing with the low-level details of a particular database vendor's API — allowing them to concentrate on domain-specific issues and build appropriate data models. Developers can write programs that are reusable with many different types of relational databases. Allows developers to drill down to the native database APIs for added control when needed.
C++ classes that encapsulate SQL 92 Data Manipulation Language (DML) and Data Definition Language (DDL) constructs.	Quickly learn to code multi-database applications because only one API must be learned. Higher-level abstractions allow for shorter, cleaner applications and facilitate code reuse.
Open SQL interface.	Take advantage of database-specific features to maximize performance. Gain tight control over statements and their binding and execution semantics.
Optional schema caching.	Improves performance in situations where database schemas do not change often.
Native Access Modules for Oracle, Microsoft SQL Server, DB2, MySQL, PostgreSQL, Sybase, and ODBC.	Provides native, high-performance implementations for supported vendor databases. Port to other databases with minimal code changes. The same API philosophy across all classes, to minimize internal training cost.