IntegrationADO.NET/5 tutorials

PowerShell data integration tutorials

Tutorials for querying and updating LDAP, MongoDB, Snowflake, ServiceNow and Jira data from PowerShell with the CData ADO.NET provider.

What this integration does

PowerShell can load .NET assemblies, so any ADO.NET provider can be used from a script: open a connection, run SQL and read the rows. That turns a directory, a SaaS application or a document database into something you can script against like a table.

How CData fits in

The CData ADO.NET Provider gives each source a SQL interface, and for sources that allow writes it supports creating, retrieving, updating and deleting records. The tutorials cover reading results into a DataTable, running scripts on a schedule, working through 403, OAuth and assembly errors, and a quick reference for MongoDB.

PowerShell tutorials by data source

Don't see your data source or tool?

CData connects hundreds of sources to the tools you already use. Browse the connectors, or talk to us about a specific setup.