Monarch Data Prep Studio Technical Specifications

Item

Specification

Input File Formats

Input via drag/drop, browse menu, or Start Page icons:

Text

PDF Reports (.pdf, .xps)
Text Reports (.dat, .prn, .rpt, .txt, .log)
Delimited Text (.csv, .tab, .txt, .dat, .tsv, .scsv)
JSON (.json)
XML (.xml)
HTML (.htm, .html)
Monarch Classic Files
- Project files (.xprj, .dprj)
- Model files (.xmod, .dmod)
PDF Table Extractor
SAS Transport File Format (XPORT) Version 5

Via Data Source Connectors:

Databases

DB2
Informix
Microsoft Access
My SQL
ODBC
OLEDB
Oracle
PostgreSQL
SQL Server
Sybase IQ
Vertica
Microsoft Access (mdb, accdb)
Microsoft Excel (.xls, .xlsx, .xlsm, .xlsb)

Applications

Business Objects
Google Ads
Google Analytics
Google Drive
Google Sheets
Hubspot
Monarch Server
NetSuite
Salesforce
SharePoint
Splunk
SugarCRM
Zendesk
Jira
Box Cloud Storage

Big Data Sources

Amazon EMR Hive
Amazon Redshift
Cassandra
Cloudera Impala
Google BigQuery
Hadoop Hive
IBM Cloudant
MongoDB
Teradata
park SQL

WEB

HTML
JSON
ODATA
XML

Export File Formats

Microsoft Excel (.xls, .xlsx, .xlsm)
Microsoft Access (.mdb, .accdb)
CSV
JSON
Microsoft Power BI
IBM Cognos Analytics
SAS Transport File Format (XPORT) Version 5
Altair Knowledge Studio (.kdd)
Tableau TDE (.tde)
Tableau Server (.tde, .hyper)
Qlik (.qvx)
Altair Panopticon (.xls, .xlsx, .xlsm)

Limits

Item	Limit
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.