Databases

Merchant Assistant stages data in several databases and data lakes

Merchant Assistant can stage all data into databases and data lakes, such as PostgreSQL, Redshift, Azure, and Aurora

MAI_Icon_Jumbo.png
database-icon.png

Staging data in a Database

Fast and Scalable Solution

All data in Merchant Assistant can be pushed into a database and staged to be queried directly and quickly. Database tables are automatically updated with the latest data from Amazon and any dashboards connected through a direct query or import pipeline results in improved performance over a traditional OData query. Merchant Assistant can push data into any relational database or columnar database.

Database Report Translation

Massage Data in the database

Once the reports have been pushed into your database of choice, tables can be massaged and customized so that the tables are clean and ready to be imported into any live dashboards. Through database scripts, you can pivot, refine, partition, and remove any rows needed.

Long term storage

Store the historical data on the database for access

By storing all the data on a database or in a data lake, you will have access to all the data from the beginning of data collection to reference. Even when the data is no longer relevant and has rolled off the reporting calendar, all the downloaded reports will be available to ad-hoc analytics.

Databases

press to zoom

press to zoom