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
Google Ads
Bing Ads
SAP Hybris C4C
Basecamp
MailChimp
Highrise CRM
LinkedIn
LinkedIn Ads
Zoho CRM
Zoho Books
Zoho Creator
Zoho Projects
WordPress
Authorize.Net
Square
OData
JSON
Microsoft Excel
Microsoft Excel Online
SharePoint Excel Services
Salesforce Marketing Cloud
Twitter
Twitter Ads
Facebook
LDAP
Amazon DynamoDB
Google Analytics
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
Microsoft Dynamics 365
Gmail
Email
Microsoft Dynamics NAV
Microsoft SharePoint
MongoDB
Azure Cosmos DB
Google BigQuery
Redis
Amazon Redshift
Amazon Athena
IBM Cloudant
Apache Cassandra
Couchbase
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 200
Sage 300
Sage Business Cloud Accounting
Sage 50 UK
Xero Accounting
Exact Online
Sage Intacct
FreshBooks
SAP Concur
QuickBase
Presto
Pipedrive
Pinterest
Apache Phoenix
Raisers Edge NXT
Reckon
XML Files
PayPal
Salesloft
SAP BusinessObjects BI
SAP Business ByDesign
SAP Fieldglass
SAP Netweaver Gateway
Reckon Accounts Hosted
Paylocity
Odoo ERP
Salesforce Pardot
Monday.com
Microsoft Planner
Microsoft Project
Microsoft Teams
MYOB AccountRight
Neo4J
Apache Parquet
SAP HANA
Microsoft OneNote
Oracle Financials Cloud
Oracle HCM Cloud
Oracle Sales
Oracle Service Cloud
Outreach.io
Microsoft OneDrive
SAP HANA XS Advanced
Slack
SAS Data Sets
Tally ERP
TaxJar
Teradata
Trello
TSheets
Twilio
Sybase IQ
Veeva Vault
WooCommerce
Marketo
Zendesk
YouTube Analytics
Workday
Xero WorkflowMax
Wave Financial
SAP SuccessFactors
Sybase
Stripe
SAS XPORT
SendGrid
ServiceNow
SFTP
ShipStation
Shopify
SurveyMonkey
SingleStore
Smartsheet
Snapchat Ads
Snowflake
Apache Spark SQL
Splunk
Streak
xBase
Kintone
CockroachDB
Bullhorn CRM
Microsoft Dataverse (CDS)
Databricks
CSV/TSV Files
Apache CouchDB
Atlassian Confluence
Zuora
Atlassian Jira Service Desk
BugZilla
Act CRM
ActiveCampaign
Box
Bing Search
BigCommerce
Active Directory
Azure DevOps
Azure Data Lake Storage
Azure Data Catalog
Act-On
Azure Active Directory
Apache Avro
Acumatica ERP
Avalara AvaTax
Asana
Amazon S3
Amazon Marketplace
Google AlloyDB
Airtable
IBM DB2
ADP
DocuSign
Dropbox
Atlassian Jira
Instagram
Apache Impala
IBM Informix
IBM Cloud SQL Query
IBM Cloud Object Storage
HubSpot
Apache Hive
Apache HDFS
HarperDB
Pivotal GreenPlum
GraphQL
Google Search
GitHub
FTP Servers
Freshdesk
FinancialForce
Facebook Ads
Microsoft Exchange
Epicor ERP
EnterpriseDB
Oracle Eloqua
Elasticsearch
Microsoft Access
Salesforce Einstein Analytics
eBay Analytics
eBay
HCL Domino
Adobe Analytics
Magento
REST
RSS Feeds
Microsoft Dynamics GP
Azure Table Storage
Microsoft SQL Server
SQLite
SQL Analysis Services
Azure Analysis Services
Azure Synapse
JDBC-ODBC Bridge
Veeva CRM
Pervasive SQL (Btrieve)
Power BI XMLA
TigerGraph
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