Monarch Data Prep Studio Technical Specifications

Inputs

Monarch Files

• Monarch Model (.xmod, .dmod)

• Monarch Project (.xprj, .dprj)

• Monarch Workspace (.dpwx)

PDF & Text

• PDF Reports (.pdf, .xps)

• Text Reports (.dat, .prn, .rpt, .txt, .log, .htm)

• Delimited Text (.csv, .tab, .txt, .dat, .tsv, .scsv)

• PDF Table Extractor

Spreadsheet

• Excel Worksheet Design

• Microsoft Excel (.xls, .xlsx, .xlsm, .xlsv, .csv)

• SAS Transport File Format V5 (.xpt, .stx)

• SAS Transport File Format V8 (.v8xpt, .xpt8, .2xpt)

Database

• DB2

• Informix

• Microsoft Access (.mdb, .accdb)

• MySQL

• ODBC

• OLEDB

• Oracle

• PostgreSQL

• Snowflake

• SQL Azure

• SQL Server

• Sybase IQ

• Teradata

• Vertica

Application

• Active Directory

• Altair Monarch Report Warehouse

• Altair Monarch Server Library

• Amazon S3

• Azure Blob Storage

• Azure Data Lake Storage Gen2

• Business Objects

• Google Analytics

• Google Cloud Storage

• Google Sheets

• HubSpot

• NetSuite

• Oracle Cloud Infrastructure

• Salesforce

• ServiceNow

• SharePoint

• Splunk

Big Data

• Amazon EMR Hive

• Amazon  Redshift

• Cassandra

• Cloudera CDH Hive

• Cloudera Impala

• Google BigQuery

• Hadoop Hive

• Hortonworks Hive

• IBM  Cloudant

• MapR Hive

• MongoDB

• Spark SQL

Web

• HTML

• JSON

• ODATA

• XML

Exports

• Microsoft Excel (.xls, .xlsx, .xlsm)

• Microsoft Access (.mdb, .accdb)

• CSV

• JSON

• XML

• PDF

• Fixed Text

• Microsoft Power BI

• IBM Cognos Analytics

• SAS Transport File Format V5

• SAS Transport File Format V8

• Altair Knowledge Studio (.kdd)

• Tableau Hyper (.hyper)

• Tableau Server (.hyper)

• Qlik (.qvx)

• Altair Panopticon (.xls, .xlsx, .xlsm)

Maximum number of input rows

Limited only by system resources.

Maximum number of output rows

Limited only by target system disk space.

Maximum Input File Size

Limited only by system resources.

Maximum Input pages

Limited only by system resources.

Maximum tables in Preview Data  from any one source

Limited only by system resources.

Maximum tables in Preview Data from all sources

Limited only by system resources.

Maximum active filters in Preview Data or Prep Data.

Limited only by system resources.

Maximum tables that can be dependent for any one Join operation

Limited only by system resources.

Maximum tables total in Prep Data

Limited only by system resources.

Maximum tables in any one load plan.

Limited only by system resources.

Maximum  recent connections/recent tables saved

Limited only by system resources.

Maximum items in a change list and custom change list

Limited only by system resources.

Maximum number of elements in a join operation.

Limited only by system resources.