Hi Folks, I am looking for some insight on if anyone has tried or been successful with using AZURE with gINT. I have been able to get the database created but I am having a few problems. When trying to upsize I get a timeout error around 30 seconds. I think that is the default in AZURE. I am not sure where to adjust if that is what it is. I can see the AZURE database in gINT but when I try to open it I get a ODBC error. "Unable to open 'Table' ODBC - Call Failed" I am curious if there has been success or any research done on the use of gINT on cloud storage.

Hello tmckenney, The word from Development is that they are working on certifying Azure for use with gINT. Sorry, we don't have a time frame for this. We'll post an announcement in the Forum when it is ready.

Enterprise Databases Hosted in AZURE

Offline tmckenney over 7 years ago

Hi Folks,

I am looking for some insight on if anyone has tried or been successful with using AZURE with gINT. I have been able to get the database created but I am having a few problems.

When trying to upsize I get a timeout error around 30 seconds. I think that is the default in AZURE. I am not sure where to adjust if that is what it is.
I can see the AZURE database in gINT but when I try to open it I get a ODBC error. "Unable to open 'Table' ODBC - Call Failed"

I am curious if there has been success or any research done on the use of gINT on cloud storage.

0 Offline tmckenney Tue, Jan 24 2017 6:59 AM in reply to Phil Wade

Hi Phil,
Over the past year we have dug in and really started to make ground on this topic. We were in a DC hosted by a data provider and that was working but wanted to move to Cloud. Just in the past few weeks we have moved all US operations to an AZURE VM environment. The only slowness we are seeing is an internal coding that Bentley is working on for output. The real rick is to have all items on the same VM, ie libraries, SQL, gINT installation.

Near future plans are to get the international offices moved over.

'Our Dirt is now in the Cloud!'

Todd McKenney
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Offline Phil Wade Mon, Jan 23 2017 7:40 PM
I tried using Azure SQL with gINT v10, still fails with OCBC error messages.

But you can of course make an Azure VM hosting an SQL Server and open that to the internet, and that works. It is not fast to access even with the Azure data centre only <20 km from my home and I have a theoretical 1 Gbps fibre connection. It takes about 9 sec to change between tables in INPUT. These speeds are what I would have expected based on my experience with on premise setups. So if you want to use Azure and get better speeds, I think the best option is to have a RDPs server in Azure with gINT installed, I'll try that next.

Phil Wade
Datgel
Bentley Channel Partner and Developer Partner
E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

Get the most out of gINT with Datgel Tools.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Offline Russ Schwab Wed, Dec 16 2015 11:09 AM

We are having the same problem, specifically associated with a SQL Azure (SaaS) database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Offline Kathleen Holcomb Tue, Nov 10 2015 10:26 AM
Hello tmckenney,

The word from Development is that they are working on certifying Azure for use with gINT. Sorry, we don't have a time frame for this. We'll post an announcement in the Forum when it is ready.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel