How does Acho work?
Acho Studio is the data warehouse we build for you to access data automatically from different production systems. It has 3 fundamental pieces to it:
- 1.Integrate data sources
- 2.Build projects with data resources
- 3.Share and publish projects
Once your data is connected, the App Builder can build interactive applications on top of it.
The first thing you would do on Acho Studio is to connect to your database. We have built connectors that will help you verify database connections instantly. See this list of data sources that we currently support.
- Flat Files (CSV, TSV, TXT, Excel)
- Databases (MySQL, SQL Server, Postgre SQL, MongoDB)
- Applications (Salesforce, HubSpot, Shopify, Google Analytics, Google Sheets, etc.)
Each integration is connected to Acho Studio . Check out our Data Connector for more info on pulling data into Acho.
A project on Acho Studio is where you can access your data resource and build on top of it. Each project contains many "tabs". Similar to your browser, you may use these tabs to access your data feed. On each tab, you will find many "actions" on the toolkit bar. These actions such as filter, join, replace and etc are similar to a SQL query. When you apply one of these actions, we will send in a query and change your table according to the action and values that you have input. You may apply as many actions as you want, and reset/undo them in sequence. Also, don't worry about losing tables in the process. All tables will be saved every step along the way.
After you have finished building the table, you can either share it with a teammate or publish it to a site or application. To share the project, all you need is your teammate's email. After sending the invitation, she/he will be able to access your project with the privileges that you have granted.
Another way to export your data is through a downloader (CSV, Excel, Google Sheet, Tableau, Metabase, etc.). For free trials, there is a 1 GB limit for each download. The best way to utilize the downloader is to control the range of your data table through actions and only download the part you want.
To publish your data on an application or a site. We have a solution that is still under development.