Products

PLATFORM

Live Connectivity

CData Drivers Live data connectors with any SaaS, NoSQL, or big data source.

CData Connect Spreadsheets Live data from anywhere, now available in spreadsheets

CData Connect Cloud Centralized SaaS platform for governed, self-service access to live data in the cloud.

API Server Create and deploy APIs from databases.

Enterprise Semantic Layer

CData Virtuality Enterprise-grade independent semantic layer.

Data Replication & ETL/ELT

CData Sync Build ETL/ELT pipelines to replicate any data source to any database or warehouse.

B2B Integration

CData Arc Comprehensive, no-code EDI and file transfer integrations in the cloud or on‑premise.

TECHNOLOGIES

For Integrators & Engineering ODBC JDBC ADO.NET Python SSIS MCP And More →

For Analysts & Data Scientists Power BI Tableau Excel Google Sheets

FEATURED

Try CData MCP Servers

Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.

Try them now for free →

2024 Gartner^® Magic Quadrant™

We are proud to share our inclusion in the 2024 Gartner Magic Quadrant for Data Integration Tools. We believe this recognition reflects the differentiated business outcomes CData delivers to our customers.

Get the Report →

CData Embedded

Software providers, give your users access to the data sources of their choice directly from your product.

Learn More →

Solutions

Connectors

CONNECTORS BY CATEGORY

View More →

FEATURED CONNECTORS

Salesforce SharePoint QuickBooks Dynamics CRM SAP NetSuite HubSpot Snowflake Google BigQuery Amazon Redshift Elasticsearch Azure Synapse MongoDB OData Amazon SP & Ads View More →

BIG DATA & NOSQL CONNECTORS

Amazon Athena Amazon DynamoDB Azure Data Catalog BigQuery Cassandra Cloudant CockroachDB Cosmos DB CouchDB Couchbase Databricks Elasticsearch Google Data Catalog Google Spanner GraphQL HBase HarperDB Hive IBM Cloud Data Engine Kafka MarkLogic MongoDB Neo4J Phoenix Presto Redis Redshift Snowflake Spark TigerGraph Trino

View More →

ERP & CRM CONNECTORS

Act CRM Act-On ActiveCampaign Acumatica Bullhorn CRM Certinia Dynamics 365 Dynamics 365 Business Central Dynamics CRM Epicor Kinetic Exact Online Highrise HubDB NetSuite Odoo Oracle Financials Cloud Oracle HCM Cloud Oracle SCM Outreach.io Pipedrive SAP SAP Ariba Source SAP ByDesign SAP Netweaver Gateway Sage 300 Salesforce Salesforce Financial Service Cloud ServiceNow Sugar CRM SuiteCRM Tally Tier1 Veeva CRM Veeva Vault Workday Zoho CRM Zoho Inventory nCino

View More →

ACCOUNTING CONNECTORS

Avalara AvaTax Dynamics GP Dynamics NAV Freshdesk MYOB AccountRight QuickBooks QuickBooks Online QuickBooks Time Reckon Reckon Accounts Hosted Sage 200 Sage Cloud Accounting Sage Intacct TaxJar Xero Zoho Books

View More →

MARKETING & ANALYTICS CONNECTORS

Adobe Analytics Bing Ads Cvent Facebook Facebook Ads Google Ads Google Analytics Google Campaign Manager 360 HubSpot Instagram LinkedIn LinkedIn Ads MailChimp Marketo Oracle Eloqua Oracle Sales Salesforce Marketing Salesforce Marketing Cloud Account Engagement Salesforce Pardot Salesloft SendGrid Snapchat Ads Splunk SurveyMonkey Tableau CRM Analytics Twitter Twitter Ads YouTube Analytics View More →

COLLABORATION CONNECTORS

Airtable Asana Azure Active Directory Azure DevOps Basecamp Bitbucket Confluence DocuSign Email Excel Excel Online GitHub Gmail Google Calendar Google Sheets Greenhouse HCL Domino Jira Jira Assets Jira Service Management Kintone Microsoft Entra ID Microsoft Exchange Microsoft Planner Microsoft Project Microsoft Teams Monday.com Office 365 Okta OneNote Oracle Service Cloud PingOne Quickbase Raisers Edge NXT SAP BusinessObjects BI SAP SuccessFactors Salesforce Data Cloud SharePoint Slack Smartsheet Trello WordPress Zendesk Zoho Creator Zoho Projects View More →

FILE & API INTEGRATION CONNECTORS

Developers

Support

SUPPORT

Support Options Submit a Support Request Knowledge Base

Subscription Manager Product Documentation

Ask questions, get answers, and engage with your peers.

Go to Community →

Resources

RESOURCES

Customer Case Studies

Customer Testimonials

Blog

Whitepapers & Webinars

CData Community

About CData Connectivity

Become a Partner

Upcoming Events

2024 Gartner^® Magic Quadrant™

Get the Report →

PLATFORM

Live Connectivity

CData Drivers Live data connectors with any SaaS, NoSQL, or big data source.

CData Connect Spreadsheets Live data from anywhere, now available in spreadsheets

CData Connect Cloud Centralized SaaS platform for governed, self-service access to live data in the cloud.

API Server Create and deploy APIs from databases.

Enterprise Semantic Layer

CData Virtuality Enterprise-grade independent semantic layer.

Data Replication & ETL/ELT

CData Sync Build ETL/ELT pipelines to replicate any data source to any database or warehouse.

B2B Integration

CData Arc Comprehensive, no-code EDI and file transfer integrations in the cloud or on‑premise.

TECHNOLOGIES

For Integrators & Engineering ODBC JDBC ADO.NET Python SSIS MCP And More →

For Analysts & Data Scientists Power BI Tableau Excel Google Sheets

FEATURED

Try CData MCP Servers

Try them now for free →

2024 Gartner^® Magic Quadrant™

Get the Report →

CData Embedded

Software providers, give your users access to the data sources of their choice directly from your product.

Learn More →

CONNECTORS BY CATEGORY

View More →

FEATURED CONNECTORS

Salesforce SharePoint QuickBooks Dynamics CRM SAP NetSuite HubSpot Snowflake Google BigQuery Amazon Redshift Elasticsearch Azure Synapse MongoDB OData Amazon SP & Ads View More →

BIG DATA & NOSQL CONNECTORS

View More →

ERP & CRM CONNECTORS

View More →

ACCOUNTING CONNECTORS

View More →

MARKETING & ANALYTICS CONNECTORS

COLLABORATION CONNECTORS

FILE & API INTEGRATION CONNECTORS

SUPPORT

Support Options Submit a Support Request Knowledge Base

Subscription Manager Product Documentation

Ask questions, get answers, and engage with your peers.

Go to Community →

RESOURCES

Customer Case Studies

Customer Testimonials

Blog

Whitepapers & Webinars

CData Community

About CData Connectivity

Become a Partner

Upcoming Events

2024 Gartner^® Magic Quadrant™

Get the Report →

PowerShell Cmdlets

PowerShell Cmdlets for Data Access

Import, export, backup, analyze, transform, & connect to your data from PowerShell

Easy-to-use Cmdlets with a simple SQL interface to Salesforce, NetSuite, MongoDB, Dynamics, Marketo, SharePoint & many more!

DOWNLOAD NOW BUY ONLINE

Connect to your Data from PowerShell

Read and write to live data from popular on-premise & cloud data sources with simple PowerShell script

Standard PowerShell modules offering straightforward integration with more than 200+ popular data sources, including NoSQL & Big Data databases, CRM, ERP, Accounting Systems, Marketing Automation, cloud platforms, and more. The Cmdlets offer a simple Transact-SQL interface for connecting with data, virtually identical to how a user would interact with a relational database like SQL server from PowerShell. With these Cmdlets you can:

Import/Export Data - Pipe data from data sources into and out-of flat-files, databases, and other data stores for archival, back-up, and synchronization.
Data Cleansing - Use PowerShell scripts to normalize and/or de-duplicate data.
Automated Integration - Connect scripts with scheduling applications like the windows scheduler to automate common integration tasks.

Install, Configure, Go!

Powerful tools that enable users to quickly and easily work with live data from virtually anywhere. Simply install a module, set the connection properties, and start building.

PS C:\> Install-Module SalesforceCmdlets_

Install Module

Download and install the latest powershell module for the Data Source that you would like to connect to.

PS C:\> $conn = Connect-Salesforce -User $user -Password $pwd -SecurityToken $myToken -UseSandbox:$false

Define Credentials

Specify the source specific connection properties. The Cmdlets support the latest in strong security and authentication, where applicable, to ensure that your data is fully protected.

PS C:\> Select-Salesforce -Connection $conn -Table lead -Columns $leadColumns -Where $leadWhereClause_

Connect to Live Data!

That is all there is to it! Users can access the use the Select, Add, Update, and Remove Cmdlets to interact with real-time data from the selected data source.

Cmdlets in Action

Use PowerShell to Connect to Data from Anywhere

Salesforce & Force.com

Microsoft Excel Online

SharePoint Excel Services

Salesforce Marketing Cloud

Google Campaign Manager 360

Dynamics 365 Business Central

Google Ad Manager

Microsoft Dynamics CRM

Microsoft Dynamics 365

Gmail

Microsoft Dynamics NAV

Sage Business Cloud Accounting

Reckon Accounts Hosted

PayPal

Salesforce Data Cloud

Salesloft

SAP Ariba Procurement

SAP Ariba Source

SAP BusinessObjects BI

Oracle Financials Cloud

SAP Business ByDesign

Veeva Vault & Vault CRM

Tableau CRM Analytics

SAP Netweaver Gateway

Atlassian Jira Service Management

Azure Data Lake Storage

Microsoft Dataverse (CDS)

Azure Active Directory

IBM Cloud Data Engine

IBM Cloud Object Storage

Microsoft Dynamics GP

Azure Table Storage

Microsoft SQL Server

SQLite

SQL Analysis Services

Azure Analysis Services

TigerGraph

Tier1

nCino

Salesforce Marketing Cloud Account Engagement

Salesforce Financial Service Cloud

Unlimited Data-Access from PowerShell

Universal Developer Subscription
200+ SOURCES	The best way to buy! A comprehensive MSDN-style subscription with unlimited access to data. … Comprehensive access to virtually all PowerShell Cmdlets. User-based license allows usage from multiple machines. Free ongoing updates, upgrades, new releases while subscription remains current.	Request Quote

Additional Options: Server, Team, Site, & Enterprise Licensing

Enable straightforward connectivity to SaaS, NoSQL, & Big Data from PowerShell across your entire organization. Contact a product specialist to learn more about our various options for Server, Team, Site, and Enterprise-wide licensing.

Request Quote