SQL Server remote connection

[Gianluca]

Hi, I have a SQL server "on premise" (no on Azure Cloud) and I'd like to use it with a Caspio app, is there the possibility to have "continuous" connection without importing the database, I mean: 

- I update my database with Python language in the continuous, then I cannot import it to Caspio all the times...I need to connect directly Caspio to the database (remote connection);

- another possibility could be connect directly my Python program to Caspio database and to update it directly "in Caspio" but I don't known if it is possible.

Any suggestion for the best way?

Thanks

Gianluca

[AtayBalunbalunan]

Hi Gianluca, Caspio Web Services API provides unlimited potentials for extending the power of Caspio and integrating it with other applications. You may want to check the documentation here: https://howto.caspio.com/web-services-api/. Web Services can be accessed through virtually any programming or scripting language including ASP, .Net, VB, PHP, C#, Cold Fusion, Java, etc. 

They also have a Professional Services team for custom development.

 

[Harbinger]

You can  import datasheet from Access or .xlsx file with Caspio. If you need to automate or programatically transfer your data from python, then consider the answer from AtayBalunbalunan.