List of Connectors

Here’s a quick list of the connectors and data sources available in Pansynchro, with the necessary information to use them in a PanSQL script.
Connection string links are to documentation where it’s available, otherwise to code describing the relevant configurators. (Better documentation is on the to-do list.) If a connection string is marked as “N/A,” simply use a blank string ('') in the PanSQL script.

	Name	Script name	Connection String	Capabilities	Requires Data Source?
	Firebird	Firebird	link	✅ Read ✅ Write ✅ Analyze	No
	Microsoft SQL Server (including Azure SQL Database)	MSSQL	link	✅ Read ✅ Write ✅ Analyze	No
	MySql	MySql	link	✅ Read ✅ Write ✅ Analyze	No
	PostgreSQL	Postgres	link	✅ Read ✅ Write ✅ Analyze	No
	Snowflake	Snowflake	link	✅ Read ✅ Write ✅ Analyze	No
	Sqlite	Sqlite	link	✅ Read ✅ Write ✅ Analyze	No
	Pansynchro binary protocol	Network	Simply use the URI or IP address of the system as the connection string.	✅ Read ✅ Write ⬜ Analyze	No
	Avro	Avro	N/A	✅ Read ✅ Write ✅ Analyze	Yes
	CSV (and similar delimited text)	CSV	link	✅ Read ✅ Write ✅ Analyze	Yes
	JSON	JSON	link	✅ Read ⬜ Write ✅ Analyze	Yes
	Parquet	Parquet	N/A	✅ Read ✅ Write ✅ Analyze	Yes
	Plain text (line-by-line)	'Text File (lines)'	N/A	✅ Read ✅ Write ✅ Analyze	Yes
	Plain text (whole file as a single entry)	'Text File (whole)'	N/A	✅ Read ✅ Write ✅ Analyze	Yes
	Debug output to console	Console	N/A	⬜ Read ✅ Write ⬜ Analyze	No

List of Data Sources

	Name	Script Name	Configuration	Capabilities
	Amazon S3 buckets (and S3-compatible storage)	S3	link	✅ Source ✅ Sink
	Google Cloud Storage	GCP	link	✅ Source ✅ Sink
	Local file storage	Files	link	✅ Source ✅ Sink
	Raw HTTP reader	Http	link	✅ Source ⬜ Sink
	REST API reader	Rest	link	✅ Source ⬜ Sink