I use PowerShell very successfully to access various database systems. Even though many people think of Microsoft SQL Server first when they think of PowerShell, the underlying processes are also available for working with other database systems. I therefore also work a lot with Oracle and PostgreSQL in my projects.
As PowerShell is based on the .NET Framework, only a matching library is required to access the database systems from both Windows and Linux.
In the presentation, I will first talk about the selection and integration of the necessary libraries and also present code that can be used to create a simple abstraction layer for accessing the data. This creates PowerShell commands for the user that only interact internally with the .NET classes and provide a standardized interface to the outside world.
In the further course of the presentation, I will then report on my projects in which I transfer large amounts of data from PostgreSQL to Oracle, for example. I will also be able to present the import from and export to Excel thanks to the PowerShell module ImportExcel.