Jump to content
  • 0

Connect to Caspio database from on-premise application


TWIRED

Question

Hi ,

I was wondering if its possible to connect bto the caspio database in my bridge account with odbc or any other api .

we wanna use our application which is on-premise in our offfice to connect and sync/update some tables  with the caspio database

 

Is this possible?

 

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0
19 hours ago, TexterVaid said:

Hi ,

I was wondering if its possible to connect bto the caspio database in my bridge account with odbc or any other api .

we wanna use our application which is on-premise in our offfice to connect and sync/update some tables  with the caspio database

 

Is this possible?

 

Hi,

You may use API or create a schedule task to import data.

Link to comment
Share on other sites

  • 0

We are considering Schedule Task to accomplish the following.

 

Our On-Premise MS SQL SERVER 2008 >>IMPORT > Caspios Data HUB >> OUR CASPIO APP(Refresh a database and some Tables)

We went through the link you provided.

 

It does not seem to have an option for MS SQL SERVER, Only Http , FTp etc

Any idea if this possible?

Thank YOU !

 

 

  • A website accessed through HTTP or HTTPS.
  • An FTP server accessed through FTP, FTPS, SFTP protocols.
  • A remote server that offers secure copy through the SCP protocol.
  • A cloud drive service such as Amazon S3, Dropbox, Google Drive, Microsoft OneDrive, or Box.
  • One or more emails (for data export by email).
Link to comment
Share on other sites

  • 0
On 11/21/2016 at 11:17 AM, TexterVaid said:

We are considering Schedule Task to accomplish the following.

 

Our On-Premise MS SQL SERVER 2008 >>IMPORT > Caspios Data HUB >> OUR CASPIO APP(Refresh a database and some Tables)

We went through the link you provided.

 

It does not seem to have an option for MS SQL SERVER, Only Http , FTp etc

Any idea if this possible?

Thank YOU !

 

 

  • A website accessed through HTTP or HTTPS.
  • An FTP server accessed through FTP, FTPS, SFTP protocols.
  • A remote server that offers secure copy through the SCP protocol.
  • A cloud drive service such as Amazon S3, Dropbox, Google Drive, Microsoft OneDrive, or Box.
  • One or more emails (for data export by email).

Hi, yes you are right, there is no option to connect sql server and caspio using data hub.

One possible option - synchronize caspio and sql via API, however this is not the best option if you have limited amount of API calls per month. You would need a lot of API calls to keep 2 databases up-to date. 

I would recommend exporting data from sql server, import to caspio and manage the database in caspio. 

 

Link to comment
Share on other sites

  • 0

Thanks Mathilda for the response, (Happy thanksgiving btw:)

We need a live automated scheduled (every 5 hours)  refresh implementation of the database unfortunately.

Its paramount to our web app and customers.

 

The options Im looking at are

a) dump local inhouse db data to xml file in aftp folder

then schedule a refresh import from caspio

 

B) I have been looking at dream factory and I think since our db is also MSSQL server , 

Im thinking API is the way to go, 

 

Thanks for your help

 

 

 

Link to comment
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...
×
×
  • Create New...