To continue with this content, please log in with your Data Access ID or create a new account.
Cancel Data Access ID
You may not be authorized to see this content. Please contact Data Access Europe for more information.
Cancel Data Access Europe
You are not authorized to see this content.
Cancel Data Access Europe
Next lesson:
Accessing Data
Cancel

Managed Connections

Introduction

In this course, we will talk about how using Managed Connections simplifies the development, deployment and support of DataFlex applications that use SQL servers for data management. We will cover a wide range of topics, including:

  • how data is accessed
  • the role of connection strings and ids
  • the basics of managed connections
  • security basics
  • alternate and additional connectionsand using dynamic connections. 
  • Finally, for developers with legacy SQL-based DataFlex applications, we’ll look at an easy method to upgrade to using managed connections.

As we work through some examples during this course, we’ll be using the Cookbook example workspace, supplied with the Learning Center course “Working with Databases”. See the links below this video. If you are new to DataFlex, we highly recommend working through that course now, so you understand the fundamental concepts about how databases are used in DataFlex.  You can also download the Cookbook workspace created during that course and follow along with the examples in this course.

Additionally, we’ll be using the latest versions of the DataFlex Studio and Microsoft SQL Server, but you can use any recent revision of DataFlex and SQL Server to complete this course. Even though we are using SQL Server, practically all the concepts covered in this course are applicable to any supported SQL environment. Before we get into the details of managed connections, it’s important to understand how data is accessed in a DataFlex environment when using SQL backends. 

Let’s get started…