Mortar has joined Datadog, the leading SaaS-based monitoring service for cloud applications. Read more about what this means here.

SQL Databases

    The relational SQL database is the canonical application data store. With a myriad number of different implementations, SQL databases are the foundation of the technical world.

    If your database has a JDBC adapter and is in Amazon EC2, you can use Mortar to store data to it from Hadoop. Data is stored transactionally, so there’s no risk of having duplicate rows inserted. By using Pig on the cloud you can dynamically scale your analysis, then store the output back to your database for further use and ad-hoc queries.

    Supported databases include:

    • Amazon RDS
    • MySQL
    • PostgreSQL
    • Oracle
    • Greenplum
    • ...any other database with a JDBC adapter