Connecting to Micros database 2

[Eric Smith]

Hello,

This is my first time posting here and I apologize if this has been answered.

I am trying to create a third party app that needs sales volumes from micros database. Only read permissions. Is there an easy way for me to do this? What information do I need?
I appreciate any help.

Thank you,

 

[Jackba]

Try connecting to the database using default credentials if your are on 3700

name=custom
pass=custom

 

[Eric Smith]

Thank you for they reply. Is there somewhere I can go to find the URL and I assume it is a cloud based DB?

 

[myu0516]

Res 3700 is not cloud based. It's Sybase SQL Anywhere.

 

[Eric Smith]

So looking farther it looks like it's SQL anywhere. This seems like a good article :

https://help.sap.com/doc/d36102f298...-US/SQL-Anywhere-Node-JS-API-Reference-en.pdf

but where will I find the url and username /password? I have access to the micros backend computer.

Also thinking about scaling this application. If you had multiple venues would you just store this connection data in your own database and then call it per venue trying to connect?

Thank you for your help.

 

[Jackba]

Try connecting to the database using default credentials if your are on 3700

name=custom
pass=custom

You can access the backend
Microsoft\Windows\Start Menu\Programs\MICROS Applications\Utilities\Database\Sybase SQL Anywhere\Sybase Central

And use the custom for read only or ask the person who installed for DBA password for read/write privileges.
Multiple venues do you mean a franchise? if so they can us 3700 EM and you just need to connect to that server. Just my thinking

 

[Eric Smith]

How would I connect to the 3700 EM? I feel I may be in over my head here.

 

[CathalMF]

Eric the databases are configured as odbc data sources.
You can open these with this windows tool.

C:\WINDOWS\syswow64\odbcad32.exe

Google how to connect to an odbc data source using whatever programming language you are using.

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website

http://www.microspostools.com/

 

[myu0516]

3700 EM is a separate product that your client must buy.

Per CathalMF said above, it's an ODBC data source. You can use web programming language to access it. But given the workload and power of a typical Res 3700 back office pc, I would say an executable file is perhaps better.

 

[Eric Smith]

Okay, Thank you guys.

I will give this a go and let you know what comes of it.