Tutorial for beginner

Watch tutorial
Video of Data Access Agility to start

Watching this short video will save you days of work

In this tutorial, you will learn how to generate data access layer for a small software application. At the end of this tutorial, you will be able to get database schema scripts, persistence entities, and data access objects for your application

Define Database Schema

Define or import your database schema using easy to use GUI without regard to database technology

Define Data Access Layer

Specify the database operations for your application without writing SQL queries

Generate Code

Download the database schema scripts, persistance entities, and data access objects

Sandy, Freelance Programmer

Before knowing Data Access Agility, I used to write SQL queries and Java code to connect applications to databases. This was taking so long, and most of the SQL queries and Java code contained bugs. I tried some ORM tools, but I still had to write SQL and Java; especially for custom queries. Then, I started to use Data Access Agility. Data Access Agility allows me to specify exactly what I need through an easy to use GUI. Once I'm ready, I can download the source code and include it in my project. Ever since, I can finish programming tasks more quickly. I also feel confident that data access layer is bug-free.

Aaron, Team Leader

We try to deliver high quality software on time. However, some software releases were failing in the testing phase. This was partially due to some bugs in the data access layer. This layer provides simplified access to the data stored in databases. What was worse, some bugs were being discovered in the production environment. This had a negative impact on our customers as well as on our reputation. One day, we decided to adopt Data Access Agility. We are now able to deliver software more quickly. We can also see that number of bugs has decreased ever since.

Jim, Software Architect

Programmers tend to violate the key principles of software architecture for the sake of meeting deadlines. One key principle is the separation of data access code from business logic and view components. Violating this principle makes applications less secure and harder to maintain. I was happy when our people started to use Data Access Agility. The code generated by this tool conforms to data access object pattern. This pattern makes the data access code isolated from other components. As a result, applications become more secure and easier to maintain.

01 

Cloud-Based Software (SaaS)

Start using Data Access Agility right away. The tool is available online; so no installation or configuration is required on your side

02

Multi-Language

Choose among different programming languages and database systems. Data Access Agility generates code for Java, C#, Python, and Node.Js applications. On the database side, Data Access Agility supports Oracle, MySql, and MS Sql Server

03

Business Intelligence (BI)

Define business intelligence operations that return aggregate data. You need the aggregate data to populate business reports and dashboards. Remember, no need for writing complex SQL queries. Just go to the Business Intelligence Panel and use the easy-to-use BI editor. Data Access Agility will then generate everything for you

04

Graphical User Interface (GUI)

Specify exactly what you need using easy to use GUI. Stop wasting time writing SQL queries and data access code for your application

05

Flexible

Define exactly what you need in one click. Data Access Agility uses the database schema to recommend a set of data access operations. You can still define custom operations that satisfy your unique requirements

06

Database Documentation

Document your database while defining its schema. Documentation will be reflected on all generated persistence entities and data access objects (E.g. As JavaDoc comments). You can also print a document that shows description of all tables and columns

5 Differences Between Hibernate and Data Access Agility

Data Access Agility is a good alternative to traditional ORMs, such as Hibernate. In this article, we highlight the major advantages of Data Access Agility over traditional ORMs.

Business Intelligence for Programmers

Business Intelligence Reporting is an important feature of any information system. In order to fulfill the reporting requirements of end-users, programmers spend good amount of time writing complex queries.