August 16, 2017 at 10:14 pm
We have a set of remote SQL Servers (2012) that are PCI and, when we rdp, require us to go through a gateway connection. So to connect to these servers, you have to enter the fqdn, UID and PW for both the gateway and the remote server. We also have a separate monitoring server where we run Python and Powershell scripts to monitor all our servers, page and alert us, etc.
I think I found a way to hit the server using Powershell. However, I would also like to use Python for some things. So my question is this: how can I hit a remote server behind a gateway that will be PCI compliant with Python? I would imagine that the question would be the same if I was using C# as well.
So far I have not been able to find a way to do this. I looked for a REST API, for example, that would work with SQL Server, and it appears this is only offered with Azure, and these servers are On Site now.
Anyway, I can't be the only one to have this need. Anyone else have a way to hit SQL Server via Python (or maybe C#) through a gateway?
August 17, 2017 at 2:33 pm
Joe Torre - Thursday, August 17, 2017 9:29 AMNot sure if this helps but I wouldn't connect via Golden Gate. Instead I would connect directly.
Looks like a great article. I've done some of that. fyi: I found out this is just an RDS gateway, so I think I should be in good shape with Python, i.e. false alarm.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply