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
Icons of varius datasource and a computer monitor showing powershell terminal and powershell logo

Connect to your Data from PowerShell

Connect to your Data from PowerShell illustrative image

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 225+ 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 Icon
Salesforce & Force.com
SAP Icon
SAP NetWeaver
SAP Business One Icon
SAP Business One
Google Ads Icon
Google Ads
Bing Ads Icon
Bing Ads
SAP Hybris C4C Icon
SAP Hybris C4C
Basecamp Icon
Basecamp
MailChimp Icon
MailChimp
Highrise Icon
Highrise CRM
LinkedIn Icon
LinkedIn
LinkedIn Ads Icon
LinkedIn Ads
Zoho CRM Icon
Zoho CRM
Zoho Books Icon
Zoho Books
Zoho Creator Icon
Zoho Creator
Zoho Projects Icon
Zoho Projects
WordPress Icon
WordPress
Authorize.Net Icon
Authorize.Net
Square Icon
Square
OData Icon
OData
JSON Icon
JSON
Excel Icon
Microsoft Excel
Excel Online Icon
Microsoft Excel Online
SharePoint Excel Services Icon
SharePoint Excel Services
Salesforce Marketing Icon
Salesforce Marketing Cloud
Twitter Icon
Twitter
Twitter Ads Icon
Twitter Ads
Facebook Icon
Facebook
LDAP Icon
LDAP
Amazon DynamoDB Icon
Amazon DynamoDB
Google Analytics Icon
Google Analytics
Google Sheets Icon
Google Sheets
Office 365 Icon
Microsoft Office 365
Google Calendar Icon
Google Calendar
Google Contacts Icon
Google Contacts
Google Drive Icon
Google Drive
Google Directory Icon
Google Directory
Google Campaign Manager Icon
Google Campaign Manager
Dynamics 365 Business Central Icon
Dynamics 365 Business Central
Google Ad Manager Icon
Google Ad Manager
Dynamics CRM Icon
Microsoft Dynamics CRM
Dynamics 365 Icon
Microsoft Dynamics 365
Gmail Icon
Gmail
Email Icon
Email
Dynamics NAV Icon
Microsoft Dynamics NAV
SharePoint Icon
Microsoft SharePoint
MongoDB Icon
MongoDB
Cosmos DB Icon
Azure Cosmos DB
BigQuery Icon
Google BigQuery
Redis Icon
Redis
Redshift Icon
Amazon Redshift
Amazon Athena Icon
Amazon Athena
Cloudant Icon
IBM Cloudant
Cassandra Icon
Apache Cassandra
Couchbase Icon
Couchbase
HBase Icon
Apache HBase
MarkLogic Icon
MarkLogic
Google Spanner Icon
Google Spanner
Google Data Catalog Icon
Google Data Catalog
Google Cloud Storage Icon
Google Cloud Storage
NetSuite Icon
NetSuite CRM & ERP
Oracle Icon
Oracle Database
MySQL Icon
MySQL
MariaDB Icon
MariaDB
PostgreSQL Icon
PostgreSQL
QuickBooks Icon
QuickBooks Desktop
SuiteCRM Icon
SuiteCRM
Sugar CRM Icon
Sugar CRM
QuickBooks Online Icon
QuickBooks Online
QuickBooks POS Icon
QuickBooks Point of Sale
Sage 300 Icon
Sage 300
Sage 200 Icon
Sage 200
Sage Cloud Accounting Icon
Sage Business Cloud Accounting
Sage 50 UK Icon
Sage 50 UK
Xero Icon
Xero Accounting
Exact Online Icon
Exact Online
Sage Intacct Icon
Sage Intacct
FreshBooks Icon
FreshBooks
SAP Concur Icon
SAP Concur
Raisers Edge NXT Icon
Raisers Edge NXT
Quickbase Icon
Quickbase
Presto Icon
Presto
Pipedrive Icon
Pipedrive
Reckon Accounts Hosted Icon
Reckon Accounts Hosted
Reckon Icon
Reckon
Salesloft Icon
Salesloft
xBase Icon
xBase
SAP Ariba Source Icon
SAP Ariba Source
Pinterest Icon
Pinterest
SAP BusinessObjects BI Icon
SAP BusinessObjects BI
SAP ByDesign Icon
SAP Business ByDesign
SAP Fieldglass Icon
SAP Fieldglass
SAP Netweaver Gateway Icon
SAP Netweaver Gateway
SAP HANA Icon
SAP HANA
SAP Ariba Procurement Icon
SAP Ariba Procurement
Phoenix Icon
Apache Phoenix
Oracle Service Cloud Icon
Oracle Service Cloud
Paylocity Icon
Paylocity
Microsoft Project Icon
Microsoft Project
Microsoft Teams Icon
Microsoft Teams
MYOB AccountRight Icon
MYOB AccountRight
Neo4J Icon
Neo4J
Odoo Icon
Odoo ERP
Microsoft OneDrive Icon
Microsoft OneDrive
OneNote Icon
Microsoft OneNote
Oracle Financials Cloud Icon
Oracle Financials Cloud
Oracle HCM Cloud Icon
Oracle HCM Cloud
Oracle Sales Icon
Oracle Sales
Oracle SCM Icon
Oracle SCM
SAP HANA XS Advanced Icon
SAP HANA XS Advanced
Outreach.io Icon
Outreach.io
Salesforce Pardot Icon
Salesforce Pardot
Parquet Icon
Apache Parquet
PayPal Icon
PayPal
SAP SuccessFactors Icon
SAP SuccessFactors
SFTP Icon
SFTP
SAS xpt Icon
SAS XPORT
TaxJar Icon
TaxJar
Teradata Icon
Teradata
Trello Icon
Trello
TSheets Icon
TSheets
Twilio Icon
Twilio
Veeva Icon
Veeva Vault
Tally Icon
Tally ERP
Wave Financial Icon
Wave Financial
Workday Icon
Workday
Microsoft Planner Icon
Microsoft Planner
Zendesk Icon
Zendesk
YouTube Analytics Icon
YouTube Analytics
XML Icon
XML Files
Zoho Inventory Icon
Zoho Inventory
WooCommerce Icon
WooCommerce
Tableau CRM Analytics Icon
Tableau CRM Analytics
Sybase IQ Icon
Sybase IQ
Sybase Icon
Sybase
SendGrid Icon
SendGrid
ServiceNow Icon
ServiceNow
Xero WorkflowMax Icon
Xero WorkflowMax
ShipStation Icon
ShipStation
Shopify Icon
Shopify
SingleStore Icon
SingleStore
Slack Icon
Slack
Smartsheet Icon
Smartsheet
Snapchat Ads Icon
Snapchat Ads
Snowflake Icon
Snowflake
Spark Icon
Apache Spark SQL
Splunk Icon
Splunk
Streak Icon
Streak
Stripe Icon
Stripe
SurveyMonkey Icon
SurveyMonkey
SAS Data Sets Icon
SAS Data Sets
Monday.com Icon
Monday.com
Databricks Icon
Databricks
CockroachDB Icon
CockroachDB
DocuSign Icon
DocuSign
DB2 Icon
IBM DB2
Microsoft Dataverse Icon
Microsoft Dataverse (CDS)
Zuora Icon
Zuora
CSV Icon
CSV/TSV Files
CouchDB Icon
Apache CouchDB
Confluence Icon
Atlassian Confluence
Marketo Icon
Marketo
Certinia Icon
Certinia
Bullhorn CRM Icon
Bullhorn CRM
Bugzilla Icon
BugZilla
Act-On Icon
Act-On
Box Icon
Box
HCL Domino Icon
HCL Domino
Blackbaud FE NXT Icon
Blackbaud FE NXT
BigCommerce Icon
BigCommerce
Acumatica Icon
Acumatica ERP
Azure DevOps Icon
Azure DevOps
Azure Data Lake Storage Icon
Azure Data Lake Storage
Azure Data Catalog Icon
Azure Data Catalog
Adobe Analytics Icon
Adobe Analytics
ADP Icon
ADP
Azure Active Directory Icon
Azure Active Directory
Avro Icon
Apache Avro
Avalara AvaTax Icon
Avalara AvaTax
Asana Icon
Asana
Amazon S3 Icon
Amazon S3
Amazon Marketplace Icon
Amazon Marketplace
Bing Search Icon
Bing Search
Dropbox Icon
Dropbox
eBay Icon
eBay
Active Directory Icon
Active Directory
Kintone Icon
Kintone
Access Icon
Microsoft Access
Jira Service Desk Icon
Atlassian Jira Service Desk
Jira Icon
Atlassian Jira
Instagram Icon
Instagram
Act CRM Icon
Act CRM
Impala Icon
Apache Impala
IBM Informix Icon
IBM Informix
IBM Cloud Object Storage Icon
IBM Cloud Object Storage
IBM Cloud Data Engine Icon
IBM Cloud Data Engine
HubSpot Icon
HubSpot
Hive Icon
Apache Hive
HDFS Icon
Apache HDFS
HarperDB Icon
HarperDB
Greenplum Icon
Pivotal GreenPlum
GraphQL Icon
GraphQL
Google Search Icon
Google Search
GitHub Icon
GitHub
FTP Icon
FTP Servers
Freshdesk Icon
Freshdesk
FHIR Icon
FHIR
Facebook Ads Icon
Facebook Ads
Microsoft Exchange Icon
Microsoft Exchange
ActiveCampaign Icon
ActiveCampaign
Epicor Kinetic Icon
Epicor Kinetic
EnterpriseDB Icon
EnterpriseDB
Oracle Eloqua Icon
Oracle Eloqua
Elasticsearch Icon
Elasticsearch
eBay Analytics Icon
eBay Analytics
AlloyDB Icon
Google AlloyDB
Airtable Icon
Airtable
Adobe Commerce Icon
Adobe Commerce
REST Icon
REST
RSS Icon
RSS Feeds
Dynamics GP Icon
Microsoft Dynamics GP
Azure Table Icon
Azure Table Storage
SQL Server Icon
Microsoft SQL Server
SQLite Icon
SQLite
Tier1 Icon
Tier1
Kafka Icon
Apache Kafka
SQL Analysis Services Icon
SQL Analysis Services
nCino Icon
nCino
Veeva CRM Icon
Veeva CRM
Salesforce Marketing Cloud Account Engagement Icon
Salesforce Marketing Cloud Account Engagement
JDBC-ODBC Bridge Icon
JDBC-ODBC Bridge
Azure Synapse Icon
Azure Synapse
Trino Icon
Trino
Azure Analysis Services Icon
Azure Analysis Services
TigerGraph Icon
TigerGraph
Power BI XMLA Icon
Power BI XMLA
Microsoft Entra ID Icon
Microsoft Entra ID

Unlimited Data-Access from PowerShell


  Universal Developer Subscription
225+
SOURCES
The best way to buy! A comprehensive MSDN-style subscription with unlimited access to data.
MongoDB Icon Cassandra Icon Couchbase Icon HBase Icon BigQuery Icon Salesforce Icon DynamicsCRM Icon NetSuite Icon SAP Icon HubSPot Icon Marketo Icon Oracle Eloqua Icon Sage Intacct Icon

  • 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.




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