Data-driven solutions like database and enterprise apps rely on connection to, and interaction with, backend databases. Backend relational databases, however, store data in tables that reflect complex data relationships. This provides numerous advantages for effective data management and data integrity but can make it difficult to access and work with the data stored therein in new ways. App developers need to have a comprehensive understanding of database design principles and the SQL query language just to get started.
In contrast, real world data relationships most often represent parent-child relationships or even deeper hierarchical structure. As such, working with hierarchical data where relationships can be visualized in a tree structure can be much simpler and more flexible, leading to faster development. This approach is also more accessible to developers without extensive SQL expertise.
To make building apps that connect to the backend relational databases that are ubiquitous in today’s enterprise easier, faster, and available to a wider range of developers, Altova MobileTogether takes an entirely unique approach. Its visual Database Wizard lets developers easily build a query that returns hierarchical data, work with that data in the app, and then easily save the data back in hierarchical form, letting MobileTogether take care of normalizing the data and writing it back to the corresponding linked tables. Let’s take a look at how it works.
Enterprise database apps are increasing in prevalence due to their advantages for enabling access to—and easy management of—the ever-growing amount of critical data business users need to work with on a day-to-day basis. Unlike other types of business productivity apps, database apps must include measures for managing different levels of user access to maintain the security and integrity of the enterprise data they expose.
This can include managing read-only and editing access rights or restrictions on access to certain types of data. While it is essential to ensure that only authorized personnel have access to confidential data, levels of permissions often vary throughout an organization. Apps built using Altova RecordsManager include comprehensive tools for managing role-based access to database data that can reflect these complicated relationships that exist within an organization.
Let’s take a look at how RecordsManager makes it easy for app administrators to manage complex role-based permissions with visual tools.
The low code approach to app creation has been very effective at decreasing the complexity and learning-curve associated with building custom apps in response to quickly changing business requirements. Low code tools do the heavy lifting for developers and system administrators, freeing them to focus on business needs and rules rather than writing complex code.
To be truly successful, any low code approach must still include the ability to configure sophisticated app behavior in response to user input. This can be a challenge to implement with visual tools.
Altova RecordsManager offers a low code approach to creating database apps, with a built-in scripting editor that is purely visual. This offers the best of both worlds: easy app creation and sophisticated functionality customized for data-centric applications. Let’s see how it works.
We’ve updated our demo series on building an app that connects to a backend database using MobileTogether. The low-code approach to app development in MobileTogether extends to database connectivity: the Database Wizard includes a visual SQL statement editor that makes it easier than ever to connect to and work with backend database data in your apps.
This how-to video series takes you through the process of developing a sample Books Catalog app with rich functionality for searching, adding new database records, working with images, and more.
Altova releases new versions of its app development framework multiple times a year to introduce new features added in response to customer requests and feedback, as well as to add support for newer OS and database versions as they become available.
The latest release of MobileTogether and RecordsManager introduces important new functionality for building low-code and no-code apps.
Like other regulatory agencies around the world, the European Banking Authority (EBA) has standardized on XBRL for the transmission of data submitted by filing entities. Benefits of using XBRL include increased accuracy and efficiency of supervisory practices and risk identification. The use of XBRL benefits filing organizations as well, because the now-standardized data can be easily validated and then used further for automated report generation and other common requirements.
However, the challenge lies in getting backend data into a valid XBRL format according to the EBA Taxonomy, especially since the employees recording the data are generally financial professionals and not familiar with XBRL syntax.
Let’s take a look at how EBA reporting tools can make it easier.
XQuery Update Facility is an extension of the XQuery language that allows you to make changes in an XML document using “update expressions” that insert, delete, replace, or rename nodes. This extension provides a convenient way to make intelligent updates to XML documents, and XMLSpy has a unique implementation that makes it even easier. Let’s see how it works.
Building Apps with an Intelligent Database Wizard
Data-driven solutions like database and enterprise apps rely on connection to, and interaction with, backend databases. Backend relational databases, however, store data in tables that reflect complex data relationships. This provides numerous advantages for effective data management and data integrity but can make it difficult to access and work with the data stored therein in new ways. App developers need to have a comprehensive understanding of database design principles and the SQL query language just to get started.
In contrast, real world data relationships most often represent parent-child relationships or even deeper hierarchical structure. As such, working with hierarchical data where relationships can be visualized in a tree structure can be much simpler and more flexible, leading to faster development. This approach is also more accessible to developers without extensive SQL expertise.
To make building apps that connect to the backend relational databases that are ubiquitous in today’s enterprise easier, faster, and available to a wider range of developers, Altova MobileTogether takes an entirely unique approach. Its visual Database Wizard lets developers easily build a query that returns hierarchical data, work with that data in the app, and then easily save the data back in hierarchical form, letting MobileTogether take care of normalizing the data and writing it back to the corresponding linked tables. Let’s take a look at how it works.
Role-based Access Control in Enterprise Apps
Enterprise database apps are increasing in prevalence due to their advantages for enabling access to—and easy management of—the ever-growing amount of critical data business users need to work with on a day-to-day basis. Unlike other types of business productivity apps, database apps must include measures for managing different levels of user access to maintain the security and integrity of the enterprise data they expose.
This can include managing read-only and editing access rights or restrictions on access to certain types of data. While it is essential to ensure that only authorized personnel have access to confidential data, levels of permissions often vary throughout an organization. Apps built using Altova RecordsManager include comprehensive tools for managing role-based access to database data that can reflect these complicated relationships that exist within an organization.
Let’s take a look at how RecordsManager makes it easy for app administrators to manage complex role-based permissions with visual tools.
Scripting App Behavior
The low code approach to app creation has been very effective at decreasing the complexity and learning-curve associated with building custom apps in response to quickly changing business requirements. Low code tools do the heavy lifting for developers and system administrators, freeing them to focus on business needs and rules rather than writing complex code.
To be truly successful, any low code approach must still include the ability to configure sophisticated app behavior in response to user input. This can be a challenge to implement with visual tools.
Altova RecordsManager offers a low code approach to creating database apps, with a built-in scripting editor that is purely visual. This offers the best of both worlds: easy app creation and sophisticated functionality customized for data-centric applications. Let’s see how it works.
How to Build a Database-driven App
We’ve updated our demo series on building an app that connects to a backend database using MobileTogether. The low-code approach to app development in MobileTogether extends to database connectivity: the Database Wizard includes a visual SQL statement editor that makes it easier than ever to connect to and work with backend database data in your apps.
This how-to video series takes you through the process of developing a sample Books Catalog app with rich functionality for searching, adding new database records, working with images, and more.
New App Development Tools
Altova releases new versions of its app development framework multiple times a year to introduce new features added in response to customer requests and feedback, as well as to add support for newer OS and database versions as they become available.
The latest release of MobileTogether and RecordsManager introduces important new functionality for building low-code and no-code apps.
How to Get EBA XBRL from Excel
Like other regulatory agencies around the world, the European Banking Authority (EBA) has standardized on XBRL for the transmission of data submitted by filing entities. Benefits of using XBRL include increased accuracy and efficiency of supervisory practices and risk identification. The use of XBRL benefits filing organizations as well, because the now-standardized data can be easily validated and then used further for automated report generation and other common requirements.
However, the challenge lies in getting backend data into a valid XBRL format according to the EBA Taxonomy, especially since the employees recording the data are generally financial professionals and not familiar with XBRL syntax.
Let’s take a look at how EBA reporting tools can make it easier.
Read more…
Learn About XQuery Update Facility
XQuery Update Facility is an extension of the XQuery language that allows you to make changes in an XML document using “update expressions” that insert, delete, replace, or rename nodes. This extension provides a convenient way to make intelligent updates to XML documents, and XMLSpy has a unique implementation that makes it even easier. Let’s see how it works.
Read more…