DataFlex Learning Center

01

Accessing Data

(4m 10s)

As developers moved to using industry-standard SQL backends, like Microsoft SQL Server, DB2, Oracle and, more recently, MySQL and PostgreSQL, the methods of accessing data in SQL and DataFlex have been refined and improved, culminating in Managed Connections.

02

Connection Strings and IDs

(5m 38s)

Now that we talked about how DataFlex connects and interacts with SQL databases, let's now look at Connection Strings and IDs.

03

Managed Connections and the cConnection class

(7m 17s)

In the previous lesson we talked about the connection string and ID. In this lesson we are going to dive into the cConnection class.

04

Security Basics

(3m 51s)

A big aspect of using any SQL backend is establishing secure access to the data, so all access requires a login.

05

Multiple Connections

(10m 37s)

Up until now, we've only used a single managed connection in our examples, but you can define multiple connections in the same configuration file.

06

Dynamic Connections

(1m 10s)

In the previous lessons we've been using connections defined in the configuration file and loaded statically. This make sense because the Studio and other tools need to be able to access them. But since managed connections are completely code-based, we can also easily create applications that change servers or databases on the fly, either by selecting the connection at startup or redirecting an existing connection at runtime.

07

Updating Legacy Applications and Conclusion

(5m 02s)

In this lesson we'll migrate the workspace to DataFlex 2022, use the Studio to create a managed connection, update the table intermediate files to use the connection ID, add the cConnection object to the application, compile and run!

DataFlex courses

Information

Using Managed Connections in DataFlex