This is the final entry in a three-part series of posts by Ginger Frost, Senior Consultant at Aptitude Software.
Ginger previously worked for Aptitude Software’s parent company, Microgen plc, in London. After resettling in the US, she worked in the intermodal transportation industry implementing various open source Business Intelligence solutions. She has recently rejoined Aptitude Software as a Senior Consultant, now based in Boston.
This series of posts came about as I reviewed what I had missed about the Aptitude Software platform while working with a wide variety of other development platforms, many of them open source. I realize the Aptitude Software platform had a number of features that made my job as a database developer and implementer so much easier.
Aptitude platform SQL Features
A significant part of the Aptitude platform’s ease of use has to do with our unique approach to visually showing SQL through a graphical interface. This allows for better collaboration between IT and the business users and gives organizations the ability to flexibly respond to architecture changes. Here are some of the specific features and the benefits they deliver to the user.
DBClarity
Aptitude differs from traditional code based environments that typically contain hundreds of source code files. Instead, it allows business users who don’t write SQL to graphically piece together syntax while the code is written behind the scenes. With this full graphical support, teams do not need any knowledge in SQL to do complex calculations or analytics. Using this method also ensures that all development is subjected to the same versioning.
SQL Visualization
The Aptitude platform also gives users the ability to “reverse engineer” SQL code by converting SQL queries and procedures into Aptitude’s graphical diagrams. This can help enterprises modernize legacy systems and transition to new database platforms. Instead of being stuck with legacy technology or having to undergo significant efforts to recode to a new language, teams can visualize existing database code and simplify migration of existing SQL from one database platform to another.
ParseSQL
The Aptitude Software Platform supports any ANSI standard SQL that a developer would attempt to write. So many database application development tools fail to parse (or correctly parse) intermediately complex but common SQL syntax, let alone do these tools accommodate a complete ANSI or ISO query standard. Unnecessary limitations on syntax or query length prevent developers from writing their most efficient and concise SQL, in turn hindering the quality of the final application.
The unique way in which the Aptitude platform visualizes in-database logic helps to improve stakeholders understanding and IT flexibility.
Please check out the first and second posts of this series for more great Aptitude platform features!
You can adjust all of your cookie settings by navigating the tabs on the left-hand side.
Our website uses strictly necessary, functional and targeting cookies to enhance your overall experience, to analyze your use and assist in our promotion and marketing efforts. If you click the ‘Accept all cookies’ button, you are agreeing to have these cookies on your device. You can also adjust your preferences for each cookie category by clicking the adjust cookie settings using the menu at left. See our privacy statement.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
Functional Cookies
This website uses Google Analytics, Marketo, CrazyEgg and Google Conversion to collect anonymous information such as the number of visitors to the site, and the most popular pages.
Keeping this cookie enabled helps us to improve our website.
Please enable Strictly Necessary Cookies first so that we can save your preferences!
Targeting Cookies
This website uses the following additional cookies:
Google Tag Manager, Pardot, LinkedIn
Please enable Strictly Necessary Cookies first so that we can save your preferences!