Skip to main content

Hi,

How to fetch data in AIMMS from a google cloud platform (GCP) database.

There is a .JSON file with me along with the queries. 

 

Hi @RwitamJ 

The big question is obviously what you mean with a google cloud platform database? 

Are you talking about Cloud SQL, or BigQuery?

For the former I guess you should be able to setup an ODBC connection, for the latter I've succesfully run a slightly annotated BigQuery OpenAPI spec through the OpenAPI client generator of the DEX library, which would provide you with client code to access BigQuery through the BigQuery REST API. I've haven't tested the latter in any way, as we don't have a BigQuery account to test it with.


Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator