The Database Connector facilitates connectivity with configured databases and allows the user to manipulate data either through the database wizard for simple queries, or through the database nodes for complex queries. This helps to leverage existing databases of an organization for data retrieval and query execution through a user-friendly GUI.

The Studio’s configuration wizard and/or administration tool defines database connections with unique names, which can be used later while creating applications. The user can define and configure various types of databases, providing necessary drivers and settings.

Once the configuration phase is completed, the user can create and test SQL queries that run for the specific connection. The queries can also contain variables (like field names) that are evaluated at runtime.