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.
Solved
Data fetching through bigquery using AIMMS
+2Best answer by MarcelRoelofs
Hi
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.
+5Hi
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.
Sign up
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.