It is possible to create an API call to SQL database?

Question

Well, probably this is a stupid question, but after to surfing the web the last week...this is my last shot.

Questions:

• It is possible to create an API to call a SQL database to retrieve records?..In a secure way..?
• What apps/tools/methods can I use? hopefully...VS, Python, PowerShell...etc
• Can I encrypt that call?and create a method to decipher the data?
• I'm not the app owner, what questions should I make to the app developer?

FYI Currently I cannot use cloud vendors or third party tools to do the transformation :(. But if there is a strong tool/vendor maybe I can negotiate it.

I have consulted:

• API to database: API to Database?

• How to quickly create a simple REST API for SQL Server database - https://medium.com/voobans-tech-stories/how-to-quickly-create-a-simple-rest-api-for-sql-server-database-7ddb595f751a

Any ideas?

Answer 1

Try rolling out redash with the bitnami stack. It's free, as in speech.

Bitnami will take care of setting up https etc if you do it on AWS. You need a t2-small I think. There's how-tos for let's encrypt etc also.

You can dish out links to "widgets" with an embedded API key. The widgets can be json or csv. They will only provide access to predefined data queries, but you can get that data from anywhere, not just your SQL server.