Add+On VELOCITY is a great fit for many businesses.Â Find out if it's the right choice for you!Â Are you looking for a Add+On VELOCITY demo, technical support, product or pricing information or to simply to compare Add+On VELOCITY with competitive options? Quickly get answers and the information you need.
In today’s fast-paced, worldwide marketplace, a company’s ability to make well-informed decisions based on current corporate data can mean the difference between success or failure. Your customers look to you, their application provider, to develop solutions that give everyone in their organization—from the chief financial officer to the warehouse manager—access to current corporate data, when and how they need it. The BASIS ODBC Driver 2.0 can help you meet your customers’ need for data by providing access to PRO/5® data through popular Windows productivity tools, database applications, and development environments.
Access to corporate data used to be difficult. Businesses could either accept a limited number of queries and reports provided by their systems developers, or spend significant amounts of time and money creating custom reports and queries. What these businesses needed was a solution that would give their employees the ability to make their own reports and queries using the Windows productivity programs—such as Access, Excel, and Crystal Reports—they already knew. In 1995, BASIS made this possible with the BASIS ODBC Driver. By providing an industry standard Application Program Interface (API) between Windows applications, BBx®, and PRO/5 databases, the BASIS ODBC Driver gave users transparent access to corporate data. Utilizing a wide variety of ODBC-aware tools, such as spreadsheets, graphics programs, and web browsers, end users could make the best use of this valuable data.
The BASIS ODBC Driver can connect popular ODBC-aware productivity tools, such as Microsoft Query and Crystal Reports, to data from local and remote servers. Today, the BASIS ODBC Driver 2.0 continues to provide reliable, transparent access to PRO/5 data, while also offering enhanced SQL grammar and ODBC capabilities, and a variety of new features. With the new 2.0 version of the BASIS ODBC Driver, you can create more sophisticated and effective queries, better manage non-normalized data, and access legacy data from the most productive, ODBC-aware applications available.
Minimum + SQL Grammar And Level 1 API The BASIS ODBC Driver 2.0 now provides Minimum + SQL Grammar and Level 1 ODBC API support. This translates into an ODBC driver that handles SQL in a more standardized way, and a shorter learning curve for new employees who already understand SQL functionality. By reaching these two levels of compliance, the BASIS ODBC Driver can now supply over 30 new Scalar functions, including—ASCII, POWER (double, integer), RAND (double), REPLACE (char, char, char), CURTIME, and DATABASE. Aggregate functions such as SUM, MEAN, and MOD are available, while functions like EXISTS, NOT EXISTS, IN, and NOT IN have been added.
Tools To Manage Non-Normalized Data The BASIS ODBC Driver preserves the investment you’ve made in existing data files by combining the powerful Views feature with a variety of new functions and capabilities. Introduced in version 1.1 of the BASIS ODBC Driver, Views let you create virtual tables defined from multiple record types, tailor the specific rows and columns that will be displayed to each end user after a query, and then save the table for future queries.
In the BASIS ODBC Driver 2.0, several features such as nested SELECTS, subqueries, and outer joins—along with Views—help you better manage non-normalized data and create more focused and powerful queries. In addition, a new multilevel logging feature enhances your ability to diagnose problems effectively. The BASIS ODBC Driver 2.0 is bundled with DDBuilder®, BASIS’ graphical data dictionary tool, to make data dictionary development and maintenance easier. Improvements in the way a View is defined within DDBuilder offer greater productivity when building a complex Data Dictionary. DDBuilder now comes with a sample database that can be used to test and demonstrate the features of DDBuilder and the BASIS ODBC Driver.
Read/Write Access The BASIS ODBC Driver 2.0 gives you the ability to choose the level of read/write access for each ODBC Driver you purchase. For developers who need fully implemented read/write capability, the ODBC Driver provides the ability to retrieve data, make changes, and update the database. When only read capability is needed, the ODBC Driver can be set to read-only status. For situations that demand the maximum level of data protection, the BASIS ODBC Driver can be licensed as an exclusively read-only product.
ODBC In Client/Server SystemsYou can help your customers further leverage their valuable corporate data by combining the BASIS ODBC Driver 2.0 with a PRO/5 Data Server for Windows NT or UNIX. Working together, the ODBC Driver client applications and the powerful PRO/5 Data Server can create high-performance, cost-effective client/server systems that are faster and more secure than a common mapped or NFS-mounted drive system.
"ODBC Drivers" is part of the Add+On VELOCITY line of products, developed by Business Software International.