im trying to access the database fom the company i work, but dont know how to do it.. Im creating an App in React Native and firebase, im using firestore as core, but i need to access an Oracle database that is hosted by the company, for some data. I was thinking in accessing it inside the firebase functions with something like oracledb from node, but dont know if it will work, as the docs say cloud functions only works with mysql postgresql and sql server. Do i have to make an backend only for accessing that? Any help is apreciated, many thanks!

Edit: Also, i have to access it from tsnames.ora, if it changes anything.

CodePudding user response：

The documentation you quoted is about Google Cloud SQL, which is a product to host managed instances of MySQL, PostgreSQL, or SQL Server on Google Cloud Platform. The limit on the DBMS platforms available there is not related to what DBMS systems you can call from Google Cloud Functions.

If your Oracle database is accessible from the internet, it should be callable from Cloud Functions too. And since Cloud Functions are fairly thin wrappers around Node.js, you'll want to start looking at how to access Oracle from Node.js.