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 |