search

mithrandyr / SimplySql

PowerShell module for querying various SQL databases
MIT License
202 stars 30 forks source link

Oracle LDAP Instruction #47

Closed SOM-SPeters closed 3 years ago

SOM-SPeters commented 3 years ago

There are no examples of how to use a ldap lookup server for oracle connections.

mithrandyr commented 3 years ago

@SOM-SPeters -- I'm not sure what exactly you are asking for.

SOM-SPeters commented 3 years ago

Instructions on connecting to an Oracle server via ldap.ora DIRECTORY_SERVERS, https://docs.oracle.com/cd/B28359_01/network.111/b28317/ldap.htm#NETRF362

mithrandyr commented 3 years ago

@SOM-SPeters -- again I am still confused. Are you wanting the documentation updated to with examples of using an LDAP lookup to connect to an oracle server? Or are you saying there needs to be changes to the oracleProvider in the module to support this?

SOM-SPeters commented 3 years ago

It is either missing or not documented how to use a Oracle LDAP server to connect to the DB server.

mithrandyr commented 3 years ago

All the provider specific Open-*Connection support provider a connectionstring directly. so you can use Open-OracleConnection -ConnectionString "Oracle-LDAP Specific Connection String Here" in order to open an oracle connection.

I have not (nor do I have any current plans) to provide greater support than this for Oracle LDAP connection scenarios. The options I provide with named parameters are for standard scenarios, they are not meant to be comprehensive -- that is where the "-ConnectionString" parameter comes in. If the provided options are not sufficient, then simply provide your own connectionstring.