Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Introduction : MS SQL Server DataServer overview
 

MS SQL Server DataServer overview

The OpenEdge DataServer for MS SQL Server allows you to access your MS SQL Server data source with the ABL and develop applications within the OpenEdge® Studio. The OpenEdge Studio is a set of tools that helps you maintain data sources and develop applications with graphical user interfaces. When you develop applications with the OpenEdge Studio, you can design a separation of your user interface, business logic, and data sources. OpenEdge Studio provides user interface independence, whether you need a character UI, a Graphical Windows UI, or a Web interface. When you incorporate a DataServer with OpenEdge Studio, you are enabling the use of your ABL business logic to access a foreign data source.
OpenEdge provides you to develop, deploy, manage, and integrate your application. The DataServer allows you to implement the OpenEdge features and ABL expansions in applications that run with the supported data sources.
Some of these tools and features are:
*OpenEdge® Application Server — Use to partition your application across multiple servers.
*Progress Dynamics® — Use to design and develop a repository-based application.
*Data Dictionary — Use to modify database schema; create indexes; and define database triggers, validation expressions, and help messages.
*Data Administration tool — Use to manage database data and perform DataServer tasks.
*Database triggers — Use to fire a block of ABL code whenever a specific data source event occurs; for example, when creating or deleting a record or assigning a value to a field.
Note that using the DataServer to access a MS SQL Server data source does not provide you with access to all ABL, WebSpeed, and database features. For details, see Initial Programming Considerations.
The OpenEdge® DataServer for MS SQL Server is a fully featured DataServer with a wide range of deployment flexibility and scalability. Its features include the following:
*It is available for use by multiple users.
*It can be configured on remote servers.
*The ODBC driver for the data source is bundled with the product.
Note: To install and use an ODBC driver successfully, your system must meet the driver system requirements for connecting to data sources. For more information, see the appropriate DataDirect product documentation at http://web.datadirect.com/support/product-info/documentation/index.html.