PowerShell Cmdlets for Data Access
Import, export, backup, analyze, transform, & connect to your data from PowerShell
- 200+ data sources supported
- Simple SQL interface to any data
- Standard PowerShell modules
- Enterprise-class security & authentication
Connect to your Data from PowerShell
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.
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 across your organization.
Automated Integration
Connect scripts with scheduling applications like the Windows Scheduler to automate common integration tasks.
Familiar SQL Interface
A simple Transact-SQL interface for connecting with data, virtually identical to how you would interact with SQL Server from PowerShell.
CData PowerShell Cmdlets in Action
See how easy it is to read and write to live data from popular on-premise & cloud data sources with simple PowerShell script using CData Cmdlets.
Available PowerShell Cmdlets
Windows PowerShell Cmdlets offering straightforward command-line access live data.
(API Driver)
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.
Install Module
Download and install the latest PowerShell module for the data source that you would like to connect to.
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.
Connect to Live Data!
That is all there is to it! Users can use the Select, Add, Update, and Remove Cmdlets to interact with real-time data from the selected data source.
The most advanced PowerShell Cmdlets anywhere
Universal Data Connectivity
Connect to the data sources that power your business: CRM, ERP, Accounting, Marketing, Collaboration, NoSQL Databases, Big Data, Cloud Storage, and more!
Robust SQL Engine
Each Cmdlet module includes a robust SQL-92 Engine that seamlessly supports bulk operations, dynamic schema & metadata discovery, and unmatched performance.
- String, Date, Numeric SQL Functions
- Collaborative Query Processing
- Query Folding / Pushdown
- Replication and Caching
Standard PowerShell Modules
CData Cmdlets are standard PowerShell modules that install seamlessly and work with all versions of PowerShell. Available on the PowerShell Gallery for easy discovery and installation.
Enterprise-Class Security
Includes standard enterprise-class security features, such as TLS/SSL data encryption for all client-server communications and support for the latest authentication standards.
Robust API Support (REST/JSON/OData)
Don't see a Cmdlet for the data source that you need? CData Subscriptions include API modules (REST/JSON/OData, etc) for integration with every and any data source.
Easily Customizable and Configurable
The data model exposed by our Cmdlets can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.
Replication and Caching
Our replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.
All-Inclusive Subscriptions
Our value-packed Universal Developer Subscription offers essential data connectivity to many popular applications, databases, and APIs.
- 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.
With the CData PowerShell Cmdlets you can...
- Read and write to live data from popular on-premise & cloud data sources with simple PowerShell script.
- Import/export data for archival, back-up, and synchronization.
- Normalize and de-duplicate data across your organization.
- Automate common integration tasks with scheduling applications.
- Interact with real-time data using familiar SQL commands.
- Connect data to analytics for BI and reporting.
Unlimited Data-Access from PowerShell
| Universal Developer Subscription | ||
|---|---|---|
|
200+ SOURCES |
The best way to buy!
A comprehensive MSDN-style subscription with unlimited access to data.
…
|
|
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