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:
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…