Product Support & Highlights
OpenAccess™ SDK

 
Key Features of Our Product:

• Headache Free Binary Product - 99% of the code comes as supported binary product. Lets face it, in today's rapidly changing technology market, the reason you would consider licensing enabling technology is to avoid building in-house expertise and maintaining it. The Interface Provider (IP) is the only source code you worry about-we provide binary linkable code for all other components. We will upgrade you with new features and all you will have to do is rebuild. Let us worry about maintaining the majority of the code for new versions of operating systems, compilers, and desktop API specifications -- our customers who used our SDK to build their ODBC drivers are able to support native OLE DB, JDBC, or ADO.NET without any additional coding.
  
  
• From the Beginning, We Were Told : Keep it Simple! - our unique toolkit design allows any C/C++, Java, or .NET programmer without knowledge of SQL, ODBC, JDBC, OLE DB, and ADO.NET to build an interface in days. Our incremental design philosophy allows you to have an interface up and running rapidly to easily do a proof of concept. Then, based on your needs, optimization and tuning can be performed over time. After all, getting to market is job one!
  
  
• Built in features that work without any coding on your part - you support 10 simple function calls in your IP. Once the IP is complete, parameter processing, joins between tables, unions, nested queries, view, disk caching, and data conversions are available without any effort on your part.
  
  
• Scalable optimization - we expose all the information you need to make use of indexes and direct access mechanisms your database supports. You have quick access to data no matter how many rows you have in your database. Our query optimizer also breaks complex queries into multiple queries that you can more efficiently process.
  
  
• Extensive SQL support - our SQL support includes select, insert, update, delete and select for update. We support row versioning to allow MS Access and other tools to efficiently insert records in a multi-user environment.
  
  
• Flexible operating mode - we work in various modes to allow you to take advantage of your data sources capabilities -- your can let us do the SQL parsing and execution, just the parsing, or pure pass through.
  
  
• Support for all data types - numeric, float, double, char, varchar, blob, integer, short integers, and variant.
  
  
• Support for large data sets - we have implementations dealing with millions of records. Our feature set includes support for processing large results sets with incremental result set retrieval to client application for "user" responsiveness and reduced server loading. Our disk caching feature allows you to control how much memory is used for intermediate processing. If this number is exceeded then we use space on the disk to process any size requests.
  
  
• Optimized client/server protocol - we package requests and results to allow fast transfer of commands and data between the client and the server. For example, the ODBC calls SQLExecute(), SQLFetch(), SQLClose() and SQLFreeStmt() are a single client/server transaction that can return as many rows as you configure it for. Also, since all the SQL processing is server based, only result sets are transmitted back to the client.
  
  
• Support for all popular platforms - we are committed to providing access to your database no matter what platform it resides on - Digital Alpha, Digital VAX, Intel, IBM RS 6000, IBM S/390, Concurrent, IBM OS/2, Sun SPARC, LINUX. OpenAccess Software's OpenRDA network software has been ported to most popular platforms and can be easily ported to new platforms. It has been designed to be platform independent. If your data resides on many platforms then the OpenAccess SDK will let your develop the IP on once platform and then build it on all the other platforms.
  
  
• Support for ODBC, JDBC, OLE DB and ADO.NET - we are committed to providing access to your database from emerging desktop standards with no change to your IP. OpenAccess will be the only middleware you will need to meet all your future desktop API requirements. We support these interfaces without the need for any third-party bridges to allow utilizing full power of the specific interface standard. For example, OLE DB can be supported by using the Microsoft OLE DB Provider for ODBC but this limits your OLE DB provider to the features of ODBC and you cannot take advantage of data types like Variant and Arrays.

 
Aiming to Make Your Life Easier...

• Optimized memory management for 24 X 7 operation - we take memory management serious to make sure you can be running 24 hours a day seven days a week without memory leaks or fragmentation.
  
  
• Detailed logging of events to file when needed - we allow detailed tracing at the ODBC and OLE DB levels and all the way down to your IP by turning on a configuration option. This simplifies your development effort and your support effort when customers call with problems. We also log details of how the query processor has optimized the query - this helps you fine tune your database access.
  
  
• Easy installation and configuration for your end users - tools are provided to easily manage the client and server software components.
  
  
• Designed for multi-platform databases - our product is setup to allow development on one platform and then to transparently build and run on all other supported platforms. We go to the extent of having a single make file that is usable on all platforms.
  
  
• Distribution kit - simply add your version of the server and you have a professional distribution kit. We can also supply our documentation electronically to let you customize and integrate into yours.

 
OpenAccess Software Will Stand Behind You ...

• Extensive support - we will support you in all phases of your design, development and deployment. Our commitment to technical support includes an invitation to spend time at our office to interact with our engineering team, prompt support over telephone and through e-mail. We also provide a knowledge base of problem resolutions on our web site. We are committed to understanding your database and making sure your IP is designed for successful deployment.
  
  
• Guaranteed compatibility with your customer's desktop tools - if for some reason our drivers do not work with a commercial 4-GL package, we will resolve it, GUARANTEED !
  
  
• Expertise in applications and tools that use ODBC, OLE DB, JDBC, and ADO.NET - we make it our business to know popular applications and tools like Microsoft Visual Basic, Microsoft Access, Sybase PowerBuilder, Crystal Reports, BEA webLogic, IBM webSphere, ColdFusion, Perl, Brio, Cognos, SQL Server, Oracle, ASP, ASP.NET, and many others
  
  
• This is our business - we have been in business since 1989 providing database access solutions. You can expect us to be around in the future.