Altair® Monarch®

 

Connectors with Case-Sensitive Filter Values

In most connector dialogs, you have the option to apply filters to limit the data that will be loaded into Monarch Data Prep Studio.

To do so, locate the column list on the dialog and check the Apply Filter on the header:

 

Then, for each column, select a filter method from the filter drop down and then enter the filter value in the Filter Value box.

Note that some data sources require case-sensitive filter values. Refer to the list below to check which data sources have case-sensitive filters.

Connectors

Connector

Case Sensitive

Active Directory

no

Amazon EMR Hive

yes

Amazon Redshift

yes

Box Cloud Storage

no

Business Objects

n/a

Cassandra

no

Cloudera CDH Hive

yes

Cloudera Impala

yes

DB2

yes

Google Ads

no

Google Analytics

n/a

Google BigQuery

no

Google Drive

no

Google Sheets

no

Hadoop Hive

yes

Hubspot

yes

IBM Cloudant

n/a

Informix

yes

Altair Monarch Server

n/a

MongoDB

n/a

MySQL

no

NetSuite

no

Odata

no

OLEDB

no

Oracle

yes

PostgreSQL

yes

Salesforce

n/a

SharePoint

no

Spark SQL

yes

Splunk

n/a

SQL Server

no

Sugar CRM

no

Sybase IQ

no

Vertica

yes

Zendesk

no