How to read data from Oracle Database via PowerShell without using ODBC or installing Oracle Client (and import it to SQL Server too)
If you read my previous article on how to configure a Linked server to Oracle , you know that I feel like someone is plotting to keep the topic of how to get our precious data outside of the Oracle ecosystem as obscure as possible out of the oracle circle Fear not!
Read MoreLoad data directly in SQL Server from a xlsx file, without OLEDB or Excel, using Powershell
I don’t know you, but people from other BU are old fashioned guys that do everything by hand, and then send you an Excel file to “put this data in the database” or “find info related to this codes”.
Read More