-1

I have a Python script which connects to SQL Server and exports the results in CSV using some Python libraries. I need to provide the ability for the team to run the Python script who does not have access to SQL Server. Is there a way I can wrap my Python into a shell and have them run that shell (executable) which will generate same CSV's?

I am open for suggestions.

Thank you!

Dale K
  • 25,246
  • 15
  • 42
  • 71
sp_analytics
  • 9

2 Answers2

0

Without providing the SQL instance itself, you cannot have a python script locally access the instance and process it, so I'm not entirely sure what you mean. You can compile your python into a binary executable, or you can try to make a package via a virtual environment that they can reproduce on their end if they have the database or another way of generating the database themselves.

Exalted Toast
  • 656
  • 5
  • 12
0

I guess you should deploy the sql service somewhere and use credentials on the python code to get the data and process it. to protect the credentials you just have to deactivate read for this file and you are all good to go

Bechir Anoir Chabchoub
  • 185
  • 10