Database Connector

Operators in the Database Connector category

Home > Database Connector

Operators

Operator	Description
AsterixDB Source	Read data from a AsterixDB instance
MySQL Source	Read data from a MySQL instance
PostgreSQL Source	Read data from a PostgreSQL instance

Total: 3 operators

Read data from a AsterixDB instance

Property	Requirement	Type	Default	Description
Host	✓	String	-
Port	✓	String	default	A port number or ‘default’
Database	✓	String	-
Table Name	✓	String	-
Limit		Long	-	Max output count
Offset		Long	-	Starting point of output
Keyword Search?		Boolean	false
↳ Keyword Search Column		String	-
↳ Keywords to Search		String	-	“[‘hello’, ‘world’], {‘mode’:‘any’}” OR "[‘hello’, ‘world’], {‘mode’:‘all’}"
Progressive?		Boolean	false
↳ Batch by Column		String	-
↳ Min		String	auto
↳ Max		String	auto
↳ Batch by Interval		Long	1000000000
Geo Search?		Boolean	false
↳ Geo Search By Columns		List	-	Column(s) to check if any of them is in the bounding box below
↳ Geo Search Bounding Box		List	-	At least 2 entries should be provided to form a bounding box. format of each entry: long, lat
Regex Search?		Boolean	false
↳ Regex Search By Column		String	-
↳ Regex to Search		String	-
Filter Condition?		Boolean	false
↳ Predicates		List	-	Multiple predicates in OR
↳ Attribute	✓	String	-
↳ Condition	✓	=, >, >=, <, <=, !=, is null, is not null	-
↳ Value		String	-

Port	Mode
0	Set Snapshot

Read data from a MySQL instance

Property	Requirement	Type	Default	Description
Host	✓	String	-
Port	✓	String	default	A port number or ‘default’
Database	✓	String	-
Table Name	✓	String	-
Username	✓	String	-
Password	✓	String	-
Limit		Long	-	Max output count
Offset		Long	-	Starting point of output
Keyword Search?		Boolean	false
↳ Keyword Search Column		String	-
↳ Keywords to Search		String	-
Progressive?		Boolean	false
↳ Batch by Column		String	-
↳ Min		String	auto
↳ Max		String	auto
↳ Batch by Interval		Long	1000000000

Port	Mode
0	Set Snapshot

Read data from a PostgreSQL instance

Property	Requirement	Type	Default	Description
Host	✓	String	-
Port	✓	String	default	A port number or ‘default’
Database	✓	String	-
Table Name	✓	String	-
Username	✓	String	-
Password	✓	String	-
Limit		Long	-	Max output count
Offset		Long	-	Starting point of output
Keyword Search?		Boolean	false
↳ Keyword Search Column		String	-
↳ Keywords to Search		String	-	E.g. ‘sore & throat’ for AND; ‘sore’, ’throat’ for OR. See official postgres documents for details
Progressive?		Boolean	false
↳ Batch by Column		String	-
↳ Min		String	auto
↳ Max		String	auto
↳ Batch by Interval		Long	1000000000

Port	Mode
0	Set Snapshot