Micros RES 3700 v. 5.6 Data Export 1

[Joseph5130]

Hello,

I am looking for a way to perform a daily export of sales data from our RES 3700 server. My accounting team would like to use Microsoft Power BI to perform a database scrape to pull the data. Has anybody had any success using this method? If so, what is the MICROS database type? I have tried to get data from a SQL server database, Oracle database & Sybase database. I keep getting an error.

If using this method is not feasible does anybody know the proper Syntax for an SQL command/query to pull sales data displaying: Date, CHECK NUMBER, Time, Day Part/Period, RVC, Major Group, QTY sold, net sales, tax rate & payment.

 

[POSN]

We do this by exporting to MS SQL. This helps with historical as Micros will purge details after 90 Days. Micros uses Sybase.

 

[Joseph5130]

Thank you very much POSN. I managed to connect to the database selecting the Sybase db format. I am having an issue finding the connections between certain tables however. Upon investigating other database export threads, I found a dbisql query that user Pmegan had suggested to join tables. I am not very well versed in SQL syntax so I am having a hard time modifying this statement:

select * from
micros.trans_dtl as tdtl join
micros.dtl as d on
tdtl.trans_seq = d.trans_seq join
micros.mi_dtl as mdtl on
d.trans_seq = mdtl.trans_seq and
d.dtl_seq = mdtl.dtl_seq join
micros.mi_def as mdef on
mdtl.mi_seq = mdef.mi_seq

I am trying to join the chk_dtl table to the tran_dtl and mi_dtl table. I believe all three tables are using the check_seq column. Would it be possible to execute a statement joinin all three tables? If so, what would the syntax be?