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

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.

  • 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.
$ 1999 00 yr




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