• More
Menu Search

OpenText Gupta SQLBase

SQLBase - The highly automated embedded database for vertical solutions and workgroups

  • Overview
  • Benefits
  • Features

OpenText™ Gupta SQLBase is a fully relational, high performance, embedded database that allows organizations to manage data closer to the customer, where capturing and organizing information is critical. SQLBase provides a self-recovering, highly automated embedded database architecture that enables users from corporate IT to ISVs to deploy SQLBase embedded in software solutions having automated deployment and configuration and automated maintenance. With its small footprint and low TCO, SQLBase is the embedded database of choice for ISVs and organizations around the world.

SQLBase integrates very well with many development tools, is highly secure and available for latest operating systems. The integrated tools allow testing for developers and to setup and configure automated maintenance with ease.

Easy ISV Licensing and Mass Deployment

SQLBase is available as an Embedded Deployment Pack (EDP) allowing you to distribute SQLBase alongside your software solutions. The SQLBase EDP contains a configuration tool that helps to maintain a count of deployed licenses. The EDP configuration tool can build custom installers for you that include everything you want to include for your customers. Before you actually build an installer you can configure how many users the included SQLBase server should be configured for. Alternatively you can just build an installation directory that includes everything SQLBase needs to run and you can use your own deployment mechanisms for distribution to your users or customers.

Automate Installation, Configuration and Maintenance

SQLBase provides automated deployment and configuration. Automated maintenance further reduces total cost of ownership of database solutions that include SQLBase.

Support for TD Mobile Mobile Workforce Apps

SQLBase is a great central database for TD Mobile mobile workforce apps. Very easy integration into the development system and easy application deployment make SQLBase a very good choice for these types of apps. Flexible licensing options allow for easy centralized deployment.

Great Companion for Team Developer Desktop Applications

In the development phase, SQLBase is an easy to manage data- base to build the initial application database structure. SQLBase excels when it comes to easy deployment of applications and included databases. SQLBase offers flexible deployment options from single-user to unlimited-user servers.

SQLBase Data Synchronization via OpenText Integration Center

Use the optional OpenText Integration Center to synchronize data between SQLBase databases or between SQLBase and other databases like Oracle, SQL Server, MySQL, PostgreSQL and more. With Integration Center you can transform data in the synch process. Create aggregate data for faster business intelligence, concatenate strings, calculate values and perform data type conversions. Integration center provides a complete toolbox of operations that can be applied while synching data between database servers.

Integration Center can be used to deploy data updates from a central location to multiple subsidiaries or to multiple end users and synch back decentral updates to a central database instance.

More about OpenText Integration Center

OpenText Business Intelligence for SQLBase Databases

Optional OpenText Business Intelligence (OTBI) is a comprehensive query and reporting solution that enables business analysts and other business users to pose questions about their data and then view the results in visually informative reports. OTBI provides decision-makers with greater insight, faster.

More about OpenText Business Intelligence

Comprehensive Software Development Support

Use virtually any software development IDE to write applications and services that connect to SQLBase database servers. SQLBase comes with an array of modern database drivers that enable software development on Windows, Linux and other platforms. SQLBase provides ODBC, OLE DB, .NET Data Provider (NDP), JDBC and native database drivers. SQLBase also installs right into Visual Studio using the DDEX extension.

SQLBase is very well integrated into OpenText Gupta Team Developer for the development of desktop business solutions and TD Mobile for mobile workforce apps using a central database.

SQLBase 64-bit and 32-bit Power

Your license of SQLBase includes a 32-bit and a 64-bit database server. You can choose what bitness to use based on your operating system capabilities. The SQLBase client drivers do also come in 32-bit and 64-bit variants. So clients and servers can be 32-bit or 64-bit depending on your machine configurations and software development practice.

Boost Your Multi-User Performance

SQLBase 12 greatly enhances database scalability and multi-user performance to keep pace with ever growing amounts of application users, application complexity and data- base growth. SQLBase 12 introduces native operating system multithreading to achieve outstanding scalability and multi-user concurrency. The performance of SQLBase 12 is highly scalable and does not decrease with a growing numbers of users.

SQLBase Command Center: Monitor, Analyze, Solve and Edit

  • Automate: Schedule recurring database maintenance tasks like daily backups, database unloads and much more. The Command Center Service will execute scheduled tasks automatically and it has the flexibility to send emails when a task is executed successfully or only if there was a problem encountered.
  • Alarms: Define thresholds for Alarms that trigger actions. For example send a notification email to an administrator if a threshold has been hit.
  • View: See the complete database structure, including Users, Roles, Tables, Indices, Views and more.
  • Operations: See all current users, current processes and current open database cursors, including details about isolation levels used and locking status.
  • Edit: Create, modify and delete all database objects via easy to use dialogs.

Highly Secure Database

Secure your sensitive data by encrypting entire SQLBase databases using powerful 256-bit AES data encryption. The communication between applications and the SQLBase database server can be encrypted using 256-bit SSL encryption to use full end-to-end encryption of all data.

SQLBase also features built-in brute-force password guessing attacks and denial-of-service attacks making it a safe and secure database for internal or external web applications as well as a safe choice as a backend database for mobile applications.

Support for latest operating system versions

  • Windows 10, Windows Server 2016
  • RedHat Linux 6 and 7

SQLBase 64-bit and 32-bit Power

Your license of SQLBase includes a 32-bit and a 64-bit database server. You can choose what bitness to use based on your operating system capabilities. The SQLBase client drivers do also come in 32-bit and 64-bit variants. So clients and servers can be 32-bit or 64-bit depending on your machine configurations and software development practice.

Try It Now

Download a free trial version of OpenText Gupta SQLBase

Download