Managing ODBC entries

[LaurentLienhard]

Hi there,

I need to create ODBC entries with Oracle driver.
I can't find any resources to do that right now.
Do you think it's something too special or that it could fall within the scope of this module?

[PlagueHO]

Hi @LaurentLienhard , do you need to install the Oracle ODBC driver or set up a system (or user) ODBC connection? I'm assuming the latter, in which case you'd probably need to fall back to using the Script resource in PSDesiredStateConfiguration module. If Oracle provide a PowerShell module for doing this it shouldn't be too hard, but if they provide a command line tool for it, then it'll be more difficult, but possible. If there is no way of scripting it though then even the DSC script resource won't be able to help. So, hopefully there is a PowerShell module for configuring ODBC connections.

[LaurentLienhard]

I am indeed in the second case.
Oracle is already installed on my server with the ODBC component.
I was thinking of using the Add-OdbcDSN command, I'm going to look at the script resource side and see if there is a powershell module.
But if not do you think making a composite resource to handle ODBC connections would be feasible or useful?