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
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
Google Sheets
Microsoft Office 365
Google Contacts
Google Drive
Google Directory
Google Campaign Manager
Dynamics 365 Business Central
Google Ad Manager
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
IBM Cloudant
Azure Data Management
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 300
Sage 50 UK
Sage 200
Xero Accounting
Exact Online
Sage Intacct
FreshBooks
SAP Concur
QuickBase
Quandl
Reckon
Raisers Edge NXT
PayPal
Power BI XMLA
Presto
Apache Phoenix
Pinterest
SAP HANA
SAS Data Sets
SAP HANA XS Advanced
SAP SuccessFactors
SAS XPORT
SAP Business ByDesign
SAP BusinessObjects BI
SAP Netweaver Gateway
SAP Fieldglass
Microsoft Planner
Marketo
Microsoft Teams
Microsoft Project
Instagram
Jira Service Desk
Jira
Kintone
Apache Kafka
Salesforce Pardot
Oracle Sales
Paylocity
Apache Parquet
Open Exchange Rates
Odoo ERP
MYOB AccountRight
Microsoft OneNote
Microsoft OneDrive
Wasabi Object Storage
Veeva Vault
WooCommerce
Wave Financial
Twilio
Teradata
TaxJar
TSheets
Trello
YouTube Analytics
XML Files
Zoho Books
Zendesk
X-Cart
Xero WorkflowMax
Workday
Zuora
xBase
Slack
SingleStore
Snapchat Ads
Smartsheet
Shopify
ServiceNow
SendGrid
ShipStation
SFTP
Sybase
SurveyMonkey
Tally ERP
Sybase IQ
Stripe
Apache Spark SQL
Snowflake
Streak
Splunk
Apache Impala
BigCommerce
Bing Search
Blackbaud FE NXT
Azure DevOps
Azure Analysis Services
Azure Data Catalog
Azure Data Lake Storage
Box
Apache CouchDB
CSV/TSV Files
Databricks
Atlassian Confluence
BugZilla
Bullhorn CRM
CockroachDB
AWS Data Management
Acumatica ERP
Adobe Analytics
ADP
Act-On
Microsoft Access
Act CRM
Active Directory
Airtable
Autify
Avalara AvaTax
Apache Avro
Asana
Alfresco
Amazon Marketplace
Amazon S3
Microsoft Dataverse (CDS)
GitHub
FTP Servers
GraphQL
Google Search
Facebook Ads
Microsoft Exchange
Freshdesk
FinancialForce
Pivotal GreenPlum
IBM Cloud Object Storage
HubSpot
IBM Informix
IBM Cloud SQL Query
Apache HDFS
HarperDB
HPCC Systems
Apache Hive
Evernote
DocuSign
EDGAR Online
eBay
Dropbox
HCL Domino
eBay Analytics
Salesforce Einstein Analytics
EnterpriseDB
Epicor ERP
DigitalOcean
IBM DB2
Elasticsearch
Oracle Eloqua
Magento
REST
RSS Feeds
Microsoft Dynamics GP
Azure Table Storage
Microsoft SQL Server
SQLite
SQL Analysis Services
JDBC-ODBC Bridge
TigerGraph
Azure Synapse
Vertica
Veeva CRM
Pervasive SQL (Btrieve)

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