SSIS PostgreSQL Source

ZappySys

|
303 clicks
| (0) | Trial
PostgreSQL Source can be used to extract large amount of data from a PostgreSQL Database. This component supports SQL language to query PostgreSQL data.
ZappySys Logo 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

 

SSIS PostgreSQL Source

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 2012, 2014, 2016, 2017 and 2019 (32 bit / 64 bit)

Click here to read more

Screenshots

drag and drop the PostgreSQL Source select connection we have created, set Access Mode to Table and select table that you want to use as source Execute the package and verify source data in file.

ZappySys SSIS PowerPack 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
  • 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.

Data Integration Categories

JSON / API Integration
Custom SSIS Tasks - Export JSON File Task Export JSON File Task Custom SSIS Tasks - JSON Source Connector (SOAP, REST, FILE) JSON File/REST API Source Custom SSIS Tasks - JSON Parser Task JSON Parser Task
Custom SSIS Tasks - JSON Generator Transform JSON Generator Transform Custom SSIS Tasks - JSON Parser Transform JSON Parser Transform Custom SSIS Tasks - JSON File Destination JSON File Destination
Custom SSIS Components - Azure Blob Source for JSON File Azure Blob Source for JSON File Custom SSIS Components - Amazon S3 Source for JSON File Amazon S3 Source for JSON File Custom SSIS Components - Secure FTP Source for JSON File Secure FTP Source for JSON File
XML Integration
Custom SSIS Tasks - Export XML File Task Export XML File Task Custom SSIS Tasks - XML Source Connector (SOAP, REST, FILE) XML File Source Custom SSIS Tasks - XML Parser Task XML Parser Task
Custom SSIS Tasks - XML Generator Transform XML Generator Transform Custom SSIS Tasks - XML Parser Transform XML Parser Transform SSIS XML Destination Connector (Create XML file) XML Destination
Custom SSIS Components - Azure Blob Source for XML File Azure Blob Source for XML File Custom SSIS Components - Amazon S3 Source for XML File Amazon S3 Source for XML File Custom SSIS Components - Secure FTP Source for XML File Secure FTP Source for XML File
CSV / Flat File Integration
Custom SSIS Components - Azure Blob Source for CSV File Azure Blob Source for CSV File Custom SSIS Components - Amazon S3 Source for CSV File Amazon S3 Source for CSV File Custom SSIS Components - Secure FTP Source for CSV File Secure FTP Source for CSV File
Custom SSIS Components - Azure Blob Destination for CSV File Azure Blob Destination for CSV File Custom SSIS Components - Amazon S3 Destination for CSV File Amazon S3 Destination for CSV File Custom SSIS Components - Secure FTP Destination for CSV File Secure FTP Destination for CSV File
Custom SSIS Components - CSV File Source CSV Source (File / Web API) Custom SSIS Tasks - CSV Destination CSV Destination Custom SSIS Components - CSV Parser Transform CSV Parser Transform
Custom SSIS Tasks - CSV Generator Transform CSV Generator Transform Custom SSIS Tasks - CSV Generator Transform Export CSV File Task
Excel Integration
Custom SSIS Excel File Source Excel Source Custom SSIS Excel File Destination Excel Destination Custom SSIS Tasks - Export Excel File Task Export Excel File Task
Microsoft Azure Cloud Integration
Custom SSIS Tasks - Azure Blob Storage Task Azure Blob Storage Task Custom SSIS Components - Azure Table Storage Source Azure Table Storage Source Custom SSIS Components - Azure Table Storage Destination Azure Table Storage Destination
Custom SSIS Components - Azure Queue Source Azure Queue Storage Source Custom SSIS Components - Azure Queue Destination Azure Queue Storage Destination Custom SSIS Components - Azure Blob Source for XML File Azure Blob Source for XML File
Custom SSIS Components - Azure Blob Source for JSON File Azure Blob Source for JSON File Custom SSIS Components - Azure Blob Source for CSV File Azure Blob Source for CSV File Custom SSIS Components - Azure Blob Destination for CSV File Azure Blob Destination for CSV File
Amazon AWS Cloud Integration
Custom SSIS Tasks - Amazon S3 Task Amazon S3 Task Custom SSIS Tasks - Amazon Redshift Data Transfer Task Amazon Redshift Data Transfer Task Custom SSIS Tasks - Amazon Redshift ExecuteSql Task Amazon Redshift ExecuteSql Task
Custom SSIS Tasks - Amazon Redshift Cluster Management Task Amazon Redshift Cluster Management Task Custom SSIS Components - Amazon DynamoDB Source Connector Amazon DynamoDB Source Custom SSIS Components - Amazon DynamoDB Destination Connector Amazon DynamoDB Destination
Custom SSIS Components - Amazon Redshift Source Amazon Redshift Source Custom SSIS Components - Amazon Redshift destination Amazon Redshift Destination Custom SSIS Components - SSIS Amazon SQS SourceAmazon SQS Queue Source
Custom SSIS Components - SSIS Amazon SQS Source Amazon SQS Queue Destination Custom SSIS Components - Amazon S3 Source for CSV File Amazon S3 Source for CSV File Custom SSIS Components - Amazon S3 Destination for CSV File Amazon S3 Destination for CSV File
Custom SSIS Components - Amazon S3 Source for XML File Amazon S3 Source for XML File Custom SSIS Components - Amazon S3 Source for JSON File Amazon S3 Source for JSON File Custom SSIS Components - Amazon AWS API Connection Amazon API Connection (Lambda, EC2, Glacier, SQS and more)
REST API, SOAP, Web API Integration
Custom SSIS Components - JSON Source (File and REST API Connector) JSON Source Connector (File, REST API) Custom SSIS Components - XML Source Connector (SOAP, REST, FILE) XML Source Connector (File, SOAP, REST API) Custom SSIS Tasks - Call REST API Task REST API Task
Custom SSIS Task - Export JSON File Task Export JSON File Task Custom SSIS Task - JSON Parser Task JSON Parser Task Custom SSIS Transform - JSON Generator Transform JSON Generator Transform
Custom SSIS Task - Web API Destination Web API Destination
Secure FTP Integration
Custom SSIS Tasks - SSIS SFTP Task - FTP, FTPS, Secure FTPSFTP Task (FTP,FTPS,Secure FTP) Custom SSIS Components - Secure FTP Source for JSON File Secure FTP Source for JSON File Custom SSIS Components - Secure FTP Source for XML File Secure FTP Source for XML File
Custom SSIS Components - Secure FTP Source for CSV File Secure FTP Source for CSV File Custom SSIS Components - Secure FTP Destination for CSV File Secure FTP Destination for CSV File
Big Data / NoSQL Integration
Custom SSIS Components - MongoDB Source Connector MongoDB Source Connector Custom SSIS Components - MongoDB Destination Connector MongoDB Destination Connector Custom SSIS Tasks - MongoDB ExecuteSQL Task MongoDB ExecuteSQL Task
Custom SSIS Tasks - Amazon Redshift Data Transfer Task Amazon Redshift Data Transfer Task Custom SSIS Tasks - Amazon Redshift Cluster Management Task Amazon Redshift Cluster Management Task Custom SSIS Tasks - Amazon Redshift ExecuteSql Task Amazon Redshift ExecuteSql Task
Custom SSIS Components - Amazon DynamoDB Source Connector Amazon DynamoDB Source Custom SSIS Components - Amazon DynamoDB Destination Connector Amazon DynamoDB Destination Custom SSIS Tasks - Amazon DynamoDB ExecuteSQL Task Amazon DynamoDB ExecuteSQL Task
Custom SSIS Components - Amazon Redshift Source Amazon Redshift Source Custom SSIS Components - Azure Table Storage Source Azure Table Storage Source Custom SSIS Components - Azure Table Storage Destination Azure Table Storage Destination
Custom SSIS Components - Amazon Redshift destination Amazon Redshift Destination
 
Salesforce Connectivity
Custom SSIS Components - Salesforce Source (Read/Query Data) Salesforce Source Connector Custom SSIS Components - Salesforce Destination (Bulk Insert, Update, Delete, Upsert) Salesforce Destination Connector Custom SSIS Components - Salesforce API Task (Call REST/SOAP API) Salesforce API Task (Call REST/SOAP API)
PostgreSQL
Custom SSIS Components - PostgreSQL Source (Read/Query Data) PostgreSQL Source Connector Custom SSIS Components - PostgreSQL Destination Connector PostgreSQL Destination Connector Custom SSIS Components - Salesforce API Task (Call REST/SOAP API) PostgreSQL ExecuteSQL Task
Microsoft Dynamics CRM (CRM Online 365 / On-Premises)
Custom SSIS Components - Microsoft Dyanmics CRM Source (Read/Extract Data) Dynamics CRM Source Connector Custom SSIS Components - Microsoft Dyanmics CRM Destination (Bulk Insert, Update, Delete, Upsert) Dynamics CRM Destination Connector
3rd Party Online Services (REST/SOAP API Connectivity)
Custom SSIS Components - Google Analytics Source Connector Google Analytics Source SSIS Google AdWords Connector - JSON/REST API Google Adwords API Integration SSIS Google Map API IntegrationGoogle Map / Geocoding API Integration
SSIS Google Drive File - SpreadSheet Export Google SpreadSheet API Integration SSIS Google DFP Integration (DoubleClick for Publisher)Google DFP API Integration SSIS Google SpreadSheet API IntegrationGoogle SpreadSheet API Integration
SSIS Google BigQuery API IntegrationGoogle BigQuery API Integration SSIS SurveyMonkey Connector - JSON/REST API SurveyMonkey API Integration SSIS HubSpot IntegrationHubSpot API Integration
SSIS Amazon MWS (Marketplace Web Service) Amazon MWS API Integration (Marketplace Web Service) SSIS Amazon Athena API Integration (AWS)Amazon Athena API Integration SSIS Amazon AWS API Integration (EC2, Lambda, Gateway)Amazon AWS API Integration (EC2, Lambda, Gateway)
SSIS Office 365 API Integration (Mail, OneDrive, Calendar, Excel, Contact)Office 365 API Integration (OneDrive, Calendar, Excel, Mail) SSIS Zendesk Connector Zendesk API Integration SSIS Twitter Connector Twitter API Integration
SSIS ServiceNow API IntegrationLinkedIn API Integration SSIS Xero API IntegrationXero API Integration SSIS Zuora API IntegrationZuora API Integration
SSIS Marketo Connector - JSON/REST API Marketo API Integration SSIS MailChimp Connector - JSON/REST API MailChimp API Integration SSIS QuickBooks Connector - JSON/REST API QuickBooks API Integration
SSIS Workday Connector - XML/SOAP API WorkDay API Integration SSIS Facebook Graph API - JSON/REST APIFacebook Graph API Integration SSIS Zoho CRM API IntegrationZoho CRM API Integration
SSIS Semantics3 Connector - XML/SOAP APISemantics3 API Integration SSIS eBay Connector - XML/SOAP API eBay API Integration SSIS SmartSheet API IntegrationSmartSheet API Integration
SSIS NetSuite ConnectorNetSuite API Integration SSIS Salesforce Marketing API Integration (ExactTarget)Salesforce Marketing API Integration (ExactTarget) SSIS LinkedIn API IntegrationLinkedIn API Integration
SSIS Zoom API IntegrationZoom API Integration SSIS TFS Online / VSTS (Visual Studio Online Team Services) ConnectorTFS API Integration (VSTS) SSIS ConstantContact API IntegrationConstantContact API Integration
SSIS JIRA API IntegrationJIRA API Integration SSIS Azure API (Cognitive Services / Sentiment Analysis)Azure API Integration (Cognitive Services) SSIS Sharepoint API IntegrationSharepoint API Integration
SSIS ExactOnline API IntegrationExactOnline API Integration SSIS Shopify API IntegrationShopify API Integration SSIS SAP S4/HANA API IntegrationSAP S4/HANA API Integration
SSIS Oracle UCM Web Service API IntegrationOracle UCM API Integration SSIS Magento API IntegrationMagento API Integration SSIS Splunk API IntegrationSplunk API Integration
SSIS ElasticSearch API IntegrationElasticSearch API Integration