Last month I sat down with Blain Barton and TechNet Edge in an interview (Blain Barton Interviews Raymond James Chad Miller on PowerShell) and described a PowerShell-based solution for providing a classic centralized data dictionary of various data sources to our IT users. I’m pleased to announce I’ve started a CodePlex project called Really Simple Data…
Tag Archive: Oracle
Querying Oracle from Powershell Part 2
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database from Powershell. In addition we’ll look at one way to handle storing sensitive password information. Querying and Oracle Database To query an Oracle database we’ll use a function called Get-OLEDBData. The code listed below and…
Querying Oracle from Powershell Part 1
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can run queries against Oracle we need to install the Oracle client on our Windows machine. Unlike SQL Server, the drivers for connecting to Oracle are not included with the operating systems. The drivers are however…
