SSIS PostgreSQL Source

ZappySys develops tools and connectors for Microsoft Business Intelligence, Azure, Amazon AWS, MongoDB and more... We provide everyday tools to make developer life easy. Check out our products including many FREE tools. If you are an MVP you may qualify for FREE MVP License

PostgreSQL Source can be used to extract large amount of data from a PostgreSQL Database. This component supports SQL language to query PostgreSQL data. PostgreSQL is a powerful, open source relational database with strong reputation for reliability, feature robustness, and performance.

Features

Multiple modes (i.e. Table or Query) to read data from PostgreSql Database
Support for data preview and max rows
Support for variable placeholders in sql query
Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory

Click here to read more

Screenshots

PostgreSQL Source Connector – Query data using SQL

SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack is designed to boost your productivity using easy to use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more. SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade
Click here to read more ...

Why SSIS PowerPack?

Coding free, drag & drop high performance suite of Custom SSIS Components and SSIS Tasks
Used by many companies around the globe
Compatible with SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016 and 2017
Support for 32bit and 64bit Server/Desktop OS
Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
No license needed if you are developing/testing in BIDS/SSDT
Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email.
30 days money back guarantee if not satisfied for whatever reason.

JSON / API Integration
Export JSON File Task	JSON File/REST API Source	JSON Parser Task
JSON Generator Transform	JSON Parser Transform	JSON File Destination
Azure Blob Source for JSON File	Amazon S3 Source for JSON File	Secure FTP Source for JSON File

XML Integration
Export XML File Task	XML File Source	XML Parser Task
XML Generator Transform	XML Parser Transform	XML Destination
Azure Blob Source for XML File	Amazon S3 Source for XML File	Secure FTP Source for XML File

CSV / Flat File Integration
Azure Blob Source for CSV File	Amazon S3 Source for CSV File	Secure FTP Source for CSV File
Azure Blob Destination for CSV File	Amazon S3 Destination for CSV File	Secure FTP Destination for CSV File
CSV Source (File / Web API)	CSV Destination	CSV Parser Transform
CSV Generator Transform	Export CSV File Task

Excel Integration
Excel Source	Excel Destination	Export Excel File Task

Microsoft Azure Cloud Integration
Azure Blob Storage Task	Azure Table Storage Source	Azure Table Storage Destination
Azure Queue Storage Source	Azure Queue Storage Destination	Azure Blob Source for XML File
Azure Blob Source for JSON File	Azure Blob Source for CSV File	Azure Blob Destination for CSV File

Amazon AWS Cloud Integration
Amazon S3 Task	Amazon Redshift Data Transfer Task	Amazon Redshift ExecuteSql Task
Amazon Redshift Cluster Management Task	Amazon DynamoDB Source	Amazon DynamoDB Destination
Amazon Redshift Source	Amazon Redshift Destination	Amazon SQS Queue Source
Amazon SQS Queue Destination	Amazon S3 Source for CSV File	Amazon S3 Destination for CSV File
Amazon S3 Source for XML File	Amazon S3 Source for JSON File	Amazon API Connection (Lambda, EC2, Glacier, SQS and more)

REST API, SOAP, Web API Integration
JSON Source Connector (File, REST API)	XML Source Connector (File, SOAP, REST API)	REST API Task
Export JSON File Task	JSON Parser Task	JSON Generator Transform
Web API Destination

Secure FTP Integration
SFTP Task (FTP,FTPS,Secure FTP)	Secure FTP Source for JSON File	Secure FTP Source for XML File
Secure FTP Source for CSV File	Secure FTP Destination for CSV File

Big Data / NoSQL Integration
MongoDB Source Connector	MongoDB Destination Connector	MongoDB ExecuteSQL Task
Amazon Redshift Data Transfer Task	Amazon Redshift Cluster Management Task	Amazon Redshift ExecuteSql Task
Amazon DynamoDB Source	Amazon DynamoDB Destination	Amazon DynamoDB ExecuteSQL Task
Amazon Redshift Source	Azure Table Storage Source	Azure Table Storage Destination
Amazon Redshift Destination

Salesforce Connectivity
Salesforce Source Connector	Salesforce Destination Connector	Salesforce API Task (Call REST/SOAP API)

PostgreSQL
PostgreSQL Source Connector	PostgreSQL Destination Connector	PostgreSQL ExecuteSQL Task

Microsoft Dynamics CRM (CRM Online 365 / On-Premises)
Dynamics CRM Source Connector	Dynamics CRM Destination Connector

3rd Party Online Services (REST/SOAP API Connectivity)
Google Analytics Source	Google Adwords API Integration	Google Map / Geocoding API Integration
Google SpreadSheet API Integration	Google DFP API Integration	Google SpreadSheet API Integration
Google BigQuery API Integration	SurveyMonkey API Integration	HubSpot API Integration
Amazon MWS API Integration (Marketplace Web Service)	Amazon Athena API Integration	Amazon AWS API Integration (EC2, Lambda, Gateway)
Office 365 API Integration (OneDrive, Calendar, Excel, Mail)	Zendesk API Integration	Twitter API Integration
LinkedIn API Integration	Xero API Integration	Zuora API Integration
Marketo API Integration	MailChimp API Integration	QuickBooks API Integration
WorkDay API Integration	Facebook Graph API Integration	Zoho CRM API Integration
Semantics3 API Integration	eBay API Integration	SmartSheet API Integration
NetSuite API Integration	Salesforce Marketing API Integration (ExactTarget)	LinkedIn API Integration
Zoom API Integration	TFS API Integration (VSTS)	ConstantContact API Integration
JIRA API Integration	Azure API Integration (Cognitive Services)	Sharepoint API Integration
ExactOnline API Integration	Shopify API Integration	SAP S4/HANA API Integration
Oracle UCM API Integration	Magento API Integration	Splunk API Integration
ElasticSearch API Integration

SSIS PostgreSQL Source

ZappySys