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 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 Icon
Salesforce & Force.com
SAP Icon
SAP ERP/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 Calendar Icon
Google Calendar
Google Sheets Icon
Google Sheets
Office 365 Icon
Microsoft Office 365
Google Contacts Icon
Google Contacts
Google Drive Icon
Google Drive
Google Directory Icon
Google Directory
Google Campaign Manager 360 Icon
Google Campaign Manager 360
Dynamics 365 Business Central Icon
Dynamics 365 Business Central
Google Ad Manager Icon
Google Ad Manager
Dynamics 365 Icon
Microsoft Dynamics 365
Dynamics CRM Icon
Microsoft Dynamics CRM
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
MariaDB Icon
MariaDB
MySQL Icon
MySQL
PostgreSQL Icon
PostgreSQL
QuickBooks Icon
QuickBooks Desktop
Sugar CRM Icon
Sugar CRM
SuiteCRM Icon
SuiteCRM
QuickBooks Online Icon
QuickBooks Online
Sage 200 Icon
Sage 200
Sage 50 UK Icon
Sage 50 UK
Sage 300 Icon
Sage 300
Sage Cloud Accounting Icon
Sage Business Cloud Accounting
Xero Icon
Xero Accounting
Exact Online Icon
Exact Online
Sage Intacct Icon
Sage Intacct
SAP Concur Icon
SAP Concur
Salesforce Data Cloud Icon
Salesforce Data Cloud
PayPal Icon
PayPal
Phoenix Icon
Apache Phoenix
PingOne Icon
PingOne
Pinterest Icon
Pinterest
Pipedrive Icon
Pipedrive
Presto Icon
Presto
Quickbase Icon
Quickbase
Raisers Edge NXT Icon
Raisers Edge NXT
SAP BusinessObjects BI Icon
SAP BusinessObjects BI
SAP Ariba Source Icon
SAP Ariba Source
SAP Ariba Procurement Icon
SAP Ariba Procurement
Reckon Accounts Hosted Icon
Reckon Accounts Hosted
Paylocity Icon
Paylocity
Salesloft Icon
Salesloft
Reckon Icon
Reckon
Parquet Icon
Apache Parquet
Microsoft Teams Icon
Microsoft Teams
Outreach.io Icon
Outreach.io
Marketo Icon
Marketo
Monday.com Icon
Monday.com
Microsoft Planner Icon
Microsoft Planner
Microsoft Project Icon
Microsoft Project
SAP ByDesign Icon
SAP Business ByDesign
MYOB AccountRight Icon
MYOB AccountRight
Neo4J Icon
Neo4J
Salesforce Pardot Icon
Salesforce Pardot
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
Oracle Service Cloud Icon
Oracle Service Cloud
Okta Icon
Okta
SAP Fieldglass Icon
SAP Fieldglass
Wave Financial Icon
Wave Financial
SAP HANA Icon
SAP HANA
Tableau CRM Analytics Icon
Tableau CRM Analytics
Tally Icon
Tally ERP
TaxJar Icon
TaxJar
Teradata Icon
Teradata
Trello Icon
Trello
QuickBooks Time Icon
QuickBooks Time
Twilio Icon
Twilio
Sybase IQ Icon
Sybase IQ
Vault CRM Icon
Veeva Vault & Vault CRM
Workday Icon
Workday
Lakebase Icon
Lakebase
xBase Icon
xBase
XML Icon
XML Files
YouTube Analytics Icon
YouTube Analytics
Zendesk Icon
Zendesk
Zoho Inventory Icon
Zoho Inventory
WooCommerce Icon
WooCommerce
SAP Netweaver Gateway Icon
SAP Netweaver Gateway
Sybase Icon
Sybase
Stripe Icon
Stripe
SAP HANA XS Advanced Icon
SAP HANA XS Advanced
SAP SuccessFactors Icon
SAP SuccessFactors
SAS Data Sets Icon
SAS Data Sets
SAS xpt Icon
SAS XPORT
SendGrid Icon
SendGrid
ServiceNow Icon
ServiceNow
SFTP Icon
SFTP
SurveyMonkey Icon
SurveyMonkey
ShipStation Icon
ShipStation
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
Shopify Icon
Shopify
Klaviyo Icon
Klaviyo
HCL Domino Icon
HCL Domino
CouchDB Icon
Apache CouchDB
Active Directory Icon
Active Directory
Act-On Icon
Act-On
DocuSign Icon
DocuSign
DB2 Icon
IBM DB2
Microsoft Dataverse Icon
Microsoft Dataverse (CDS)
Databricks Icon
Databricks
Cvent Icon
Cvent
CSV Icon
CSV/TSV Files
Kintone Icon
Kintone
Confluence Icon
Atlassian Confluence
CockroachDB Icon
CockroachDB
Certinia Icon
Certinia
Bullhorn CRM Icon
Bullhorn CRM
Acumatica Icon
Acumatica ERP
Zuora Icon
Zuora
Box Icon
Box
Bitbucket Icon
Bitbucket
BigCommerce Icon
BigCommerce
Adobe Analytics Icon
Adobe Analytics
Azure DevOps Icon
Azure DevOps
Azure Data Lake Storage Icon
Azure Data Lake Storage
Azure Data Catalog Icon
Azure Data Catalog
Adobe Target Icon
Adobe Target
Azure Active Directory Icon
Azure Active Directory
Avro Icon
Apache Avro
Avalara AvaTax Icon
Avalara AvaTax
ADP Icon
ADP
Asana Icon
Asana
Airtable Icon
Airtable
Amazon S3 Icon
Amazon S3
Blackbaud FE NXT Icon
Blackbaud FE NXT
Amazon Marketplace Icon
Amazon Marketplace
Dropbox Icon
Dropbox
eBay Analytics Icon
eBay Analytics
Jira Service Management Icon
Atlassian Jira Service Management
Access Icon
Microsoft Access
Jira Assets Icon
Jira Assets
Jira Icon
Atlassian Jira
Instagram Icon
Instagram
Impala Icon
Apache Impala
IBM Informix Icon
IBM Informix
Act CRM Icon
Act CRM
IBM Cloud Object Storage Icon
IBM Cloud Object Storage
HubSpot Icon
HubSpot
HubDB Icon
HubDB
Hive Icon
Apache Hive
HDFS Icon
Apache HDFS
HarperDB Icon
HarperDB
eBay Icon
eBay
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
Epicor Kinetic Icon
Epicor Kinetic
EnterpriseDB Icon
EnterpriseDB
Oracle Eloqua Reporting Icon
Oracle Eloqua Reporting
ActiveCampaign Icon
ActiveCampaign
Oracle Eloqua Icon
Oracle Eloqua
Elasticsearch Icon
Elasticsearch
Greenhouse Icon
Greenhouse
AlloyDB Icon
Google AlloyDB
Adobe Commerce Icon
Adobe Commerce
REST Icon
REST
RSS Icon
RSS Feeds
Azure Table Icon
Azure Table Storage
SQL Server Icon
Microsoft SQL Server
SQLite Icon
SQLite
SQL Analysis Services Icon
SQL Analysis Services
Microsoft Entra ID Icon
Microsoft Entra ID
nCino Icon
nCino
Power BI XMLA Icon
Power BI XMLA
Veeva CRM Icon
Veeva CRM
Salesforce Financial Service Cloud Icon
Salesforce Financial Service Cloud
Salesforce Marketing Cloud Account Engagement Icon
Salesforce Marketing Cloud Account Engagement
JDBC-ODBC Bridge Icon
JDBC-ODBC Bridge
Trino Icon
Trino
Azure Synapse Icon
Azure Synapse
TigerGraph Icon
TigerGraph
Tier1 Icon
Tier1
Azure Analysis Services Icon
Azure Analysis Services
Apache Doris Icon
Apache Doris
Kafka Icon
Apache Kafka



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