Data Prep Studio Technical Specifications

Item

Specification

Input File Formats

Input via drag/drop, via browse menu, or via 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)

Databases

Microsoft Access (mdb, accdb)
Microsoft Excel (xls, xlsx, xlsm)

Via Data Source Connectors:

Databases

SQL Server
PostgreSQL
MySQL
Splunk
OLEDB
Monarch Server - Content
Salesforce
Oracle
Informix
DB2
ODBC
Google Analytics

Big Data Sources

MongoDB
IBM Cloudant
Sybase IQ
Cloudera Impala
Amazon Redshift
Hadoop Hive

WEB

OData

Big Data Sources

Business Objects Universe

Monarch Files

Project files (.xprj, .dprj)
Model files (.xmod, .dmod)

Export File Formats

Delimited File (CSV)
MS Excel
MS Access
Monarch Swarm
Datawatch Designer
Qlik
Tableau/Tableau Server
IBM Watson Analytics
IBM Cognos Analytics
Monarch Swarm

Limits

Item	Limit
Maximum number of input rows	100K rows
Maximum number of output rows	1k rows
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.