Jump to content
  • 0
Sign in to follow this  
Gianluca

SQL Server remote connection

Question

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

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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.

 

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...