Tutorial for beginner
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 or import your database schema using easy to use GUI without regard to database technology
Specify the database operations for your application without writing SQL queries
Download the database schema scripts, persistance entities, and data access objects
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.
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.
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.
Start using Data Access Agility right away. The tool is available online; so no installation or configuration is required on your side
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
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
Specify exactly what you need using easy to use GUI. Stop wasting time writing SQL queries and data access code for your application
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
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
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.
14th June, 2018
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.
8th November, 2018