Aufinia ® 2018

Empower your teams with access to dynamic dashboards

Read more

Someone once said to me that we should use an advanced system, such as SQL, rather than an outdated one such as ACL.

At that time, I started to learn about SQL and these are some of the points that came out of that learning:

1/ SQL does not support the import of any data type, whereas ACL does

2/ SQL requires a server environment, whereas ACL can run either on a PC or on a server

3/ SQL requries a lot of memory, whereas ACL can run on any machine

4/ SQL requires a database administrator in order to periodically clean-up disk-space that has been locked down by the database, whereas ACL does not

5/ SQL may crash and destroy all of the information in your database, due to locking of data sources or queries, whereas ACL does not

6/ SQL may require hours or days to recover from a system crash, where as ACL will require only a few minutes

7/ SQL is quite complicated to understand, a select statement will be many lines of code, whereas ACL can usually do the same action in one line of code

8/ SQL code can generally speaking, only be understood by an IT professional, whereas ACL has command buttons and a log that enables you to record scripts, and replay them, without knowing anything about IT

9/ SQL can only export to a limited number of file types, whereas ACL can export to Excel, text, XML, JSON, etc.

10/ SQL does not support internal control workflow, audit matrices, viewing of results on mobile devices, data visualization, etc. whereas ACL does

11/ ACL is quicker in terms of performance than SQL

12/ ACL is cheaper in terms of licencing than SQL

13/ ACL has ACL clubs, conferences and international events including attendees from areas of internal audit, internal control, risk management, whereas SQL does not

14/ ACL can be used to schedule analysis, whereas SQL cannot

15/ An ACL programme can be sent via email, whereas an SQL database cannot

16/ ACL logs all actions carried out on the data and this log can be used for auditors, whereas SQL does not

17/ ACL logs can be used to create automated scripts to repeat work, whereas SQL does not have such logs

18/ ACL has easy to use buttons in order to carry out most functions, whereas SQL does not

19/ Staff can become an ACL Certified Data Analyst and this qualification is recognised in the professions of audit and internal control, wheras qualifications in SQL are not recognized

20/ SQL can be used in a team environment and so can ACL. However, ACL has the functionality to  manage code versions, in a code library, whereas SQL does not

After experiencing the use of ACL and SQL, as well as other tools, at Aufinia we are convinced that ACL is the most cost-effective and powerful tool on the market.

If you would like any further information about comparisons between ACL or SQL, please do not hesitate to contact us and we can demonstrate these two tools for you.