Notasi BETA v0.1

…all your data StoredScheduledQueriedConnectedVisualised
…all without a DBA

Download Now

What Can Notasi Do

No DBA Needed!

Don’t worry about data types, complex database architecture or time consuming ETL processes. Just enter the connection details, the query options, and what values make the information unique and Notasi handles the rest. It even stores a full history of all changes made to the data.

Once you’ve got your data, schedule with familiar and powerful CRON scheduling.

  • SQL
  • LDAP

All your data in one place!

Combine your data sources effortlessly, all you need is a little bit of SQL. Database views are automatically generated, so querying your data is as simple as can be!

  • Direct database connection
  • Custom REST APIs

No more waiting for underpowered 1st party connectors

Don't wait for your "favourite" software company to develop the connectors you need, do it yourself without the stress of custom development. Use the data stored in Notasi as variables in API calls and SQL queries

New Dashboards in Seconds!

Build mobile ready dashboards and embed them in record time. Notasi handles the layout, pagination and permissions so you can focus on communicating insights to your users!

  • Responsive Layout
  • Automatic Pagination
  • As simple or as complex as you need
  • Row level security
  • Expand built in capabilities (Chart.js)

Use Notasi for

Run SQL on your spreadsheets!

Spreadsheets still have an incredibly important role in most businesses, but unless you want to hire a VBA developer, using this data is clumsy and manual. Notasi lets you build SQL views from spreadsheets without stressing over schema particulars, and you get to see a full history of the information stored. If you're looking for a more resilient, reliant way of running analytics on your data, Notasi is your perfect solution.

Build powerful APIs with a little bit of SQL!

If you have security concerns about opening up your database to third party applications, Notasi has a quick and clean solution. You can build custom REST API's that only access the data you want it to. Just enter a SQL query, and then any column returned is available as a variable to include in your request body or as URL parameters.

See what your data looked like at any point in time!

Notasi is really clever in the way it stores your data. Every time you write data into Notasi, it checks what information has changes since the last write. It timestamps all the data and lets you know whether a certain piece of information came through in the last write.

Replacing your custom, hard to maintain scripts is easy with Notasi. But how does it work?

First you need to get all your data out of your SIS. Notasi doesn't mind which system the information is coming from, and you can access it over REST APIs, SQL Queries or even CSV or JSON files. You can pull in all your users, their classes and even the assessments from the SIS.

Next you'll need to get the newly stored data from Notasi and into your LMS. With most systems, you can do that with their REST API, so set up a new connection with the URL for the LMS. Then, create a new query:

  1. Enter the query's name and associated location
  2. Enter a SQL Query to get the data from Notasi
  3. Choose an endpoint and request type
  4. Finally, enter a header and body for the request. You can use {curly brackets} around column names from the data lake query to include variables. It will make one request per row returned by the data lake query
You'll need to repeat steps 1-4 for every type of data you want to sync (e.g. students, classes, assessments), depending on how your LMS uses the provided information.

Retrieving assessment results is just as easy, just set up the queries and store the information with views.

Personal dashboards for all your users!

Once you've got some data in Notasi, you might want to set up dashboards

Want to Use Notasi? Get In Touch

We'll never share your email with anyone else.