Once you have integrated a database into your application, you need a way to access the data within the database and use it from within the app. There are many ways to achieve this:
- Create a Variable for the Database CRUD APIs auto-generated for each table within the database. This is the easiest and most efficient way to handle the database. This Variable will be of the same structure as the table and can act as a liaison between the app and the database. Know more about variables.
- Queries, Stored Procedures and Database Views can be used to manipulate data. These can be used for getting custom data, work with multiple tables and much more.
- Database Tools help you in accessing the DB Shell to work with the database directly. It also has provision to run scripts to import/export database.