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
Microsoft Office 365
Google Calendar
Google Sheets
Google Contacts
Google Drive
Google Directory
Google Campaign Manager
Dynamics 365 Business Central
Google Ad Manager
Microsoft Dynamics 365
Microsoft Dynamics CRM
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
MySQL
MariaDB
PostgreSQL
QuickBooks Desktop
Sugar CRM
SuiteCRM
QuickBooks Online
QuickBooks Point of Sale
Sage Business Cloud Accounting
Sage 200
Sage 300
Sage 50 UK
Xero Accounting
Exact Online
Sage Intacct
FreshBooks
SAP Concur
Raisers Edge NXT
QuickBase
Pipedrive
Pinterest
Apache Phoenix
Presto
Reckon
XML Files
Salesloft
PayPal
SAP BusinessObjects BI
SAP Business ByDesign
SAP Fieldglass
SAP Netweaver Gateway
SAP HANA
Reckon Accounts Hosted
Paylocity
Oracle HCM Cloud
Salesforce Pardot
Microsoft Planner
Microsoft Project
Microsoft Teams
MYOB AccountRight
Neo4J
Odoo ERP
Apache Parquet
Microsoft OneDrive
Oracle Financials Cloud
SAP HANA XS Advanced
Oracle Sales
Oracle SCM
Oracle Service Cloud
Outreach.io
Microsoft OneNote
SAP SuccessFactors
Shopify
SAS XPORT
TaxJar
Teradata
Trello
TSheets
Twilio
Veeva Vault
Tally ERP
Wave Financial
Workday
Monday.com
Zoho Inventory
Zendesk
YouTube Analytics
Xero WorkflowMax
WooCommerce
Tableau CRM Analytics
Sybase IQ
Sybase
SendGrid
ServiceNow
SFTP
ShipStation
xBase
SingleStore
Slack
Smartsheet
Snapchat Ads
Snowflake
Apache Spark SQL
Splunk
Streak
Stripe
SurveyMonkey
SAS Data Sets
Marketo
Apache CouchDB
CockroachDB
Microsoft Dataverse (CDS)
Databricks
CSV/TSV Files
Zuora
Atlassian Confluence
Kintone
Bullhorn CRM
BugZilla
Act CRM
ActiveCampaign
Box
Bing Search
BigCommerce
Active Directory
Azure DevOps
Azure Data Lake Storage
Azure Data Catalog
Act-On
Acumatica ERP
Azure Active Directory
Apache Avro
Avalara AvaTax
Asana
Amazon S3
Amazon Marketplace
Google AlloyDB
Airtable
IBM DB2
DocuSign
HCL Domino
Dropbox
Atlassian Jira Service Desk
Atlassian Jira
Instagram
Apache Impala
IBM Informix
IBM Cloud SQL Query
IBM Cloud Object Storage
HubSpot
Apache Hive
Apache HDFS
HarperDB
Pivotal GreenPlum
GraphQL
ADP
Google Search
FTP Servers
Freshdesk
FinancialForce
FHIR
Facebook Ads
Microsoft Exchange
Epicor ERP
Microsoft Access
EnterpriseDB
Oracle Eloqua
Elasticsearch
eBay Analytics
eBay
GitHub
Adobe Analytics
Magento
REST
RSS Feeds
Microsoft Dynamics GP
Azure Table Storage
Microsoft SQL Server
SQLite
SQL Analysis Services
Azure Analysis Services
Azure Synapse
Veeva CRM
JDBC-ODBC Bridge
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