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
JiraRead Jira Issues in PowerShell: Common Questions Answered
Answers on reading Jira issues from PowerShell with the CData ADO.NET provider: credentials and API tokens, the Issues and Projects tables, joins, and exports.
LDAPQuery an LDAP Directory from PowerShell and Get Back a DataTable
Connect to LDAP from PowerShell with the CData ADO.NET provider, read the User table into a DataTable, and update, insert or delete entries with parameters.
MongoDBMongoDB in PowerShell: ADO.NET Connection and CRUD Cheat Sheet
PowerShell snippets for the CData ADO.NET Provider for MongoDB: connection strings, SELECT into a DataTable, parameterized update, insert and delete, plus errors.
ServiceNowServiceNow in PowerShell: Fixing 403s, OAuth and Assembly Errors
Fix the first-run failures when querying ServiceNow from PowerShell with the CData ADO.NET provider: 403 on discovery, OAuth settings and assembly load errors.
SnowflakeRun Snowflake Queries from a Scheduled PowerShell Script
Turn a Snowflake query into an unattended PowerShell job with the CData ADO.NET provider: non-interactive login, CSV output, clean failures, a scheduled task.
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.