Connect to Caspio database from on-premise application

[TWIRED]

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?

 

[Mathilda]

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.

[TWIRED]

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).

[Mathilda]

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. 

 

[TWIRED]

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

 

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