Need help with Micros Simphony

[Tombodacious]

I'm starting to work with a client next week who is running Micros Simphony (V1.6) and I'm looking to see if there is a way to extract basic data out of the POS. All my research that I'm finding says that it is a SQL based; however, I'm not finding any documentation on hooking up to the system. The long story short I'm trying to build a sort of datawarehouse for them with data from a few other systems and this is one that I'm stumbling over. I've worked with some of the older Micros systems and have had great luck getting data out; however, seem to be a little stumped on this one. Would anyone know how to get some data extracted from this system?
Thanks

 

[Moregelen]

Depends. Symphony can use Microsoft SQL or Oracle. Find out which they are using. If they are using Microsoft SQL you can still setup an ODBC connection if you want, using the SQL Server driver. If its oracle.. I have no idea. Its probably Microsoft SQL though.

 

[Tombodacious]

Thanks for the info and good to here, I found a few documents leading me in that direction. From what I've uncovered (about a half hour ago) a 'System Database User' account has to be set up for authentication (unlike the old ones that had standard credentials). Are you aware if the table structure is the same as some of the older ones? ie: micros.chk_dtl

 

[Moregelen]

It has a lot of similarities but at the same time it is also very different. The table structures aren't the same. So while there is a microsdb.CHECK_DETAIL table, its not the same. Doesn't even store close to the same information.

Heres a select statement of the check detail table to tell you what the columns are. You're really going to need a database to play with.

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [CheckDetailID]
      ,[CheckID]
      ,[DetailIndex]
      ,[DetailType]
      ,[Status]
      ,[Seat]
      ,[RevCtrID]
      ,[EmployeeID]
      ,[SalesCount]
      ,[Total]
      ,[VoidLink]
      ,[Numerator]
      ,[Denominator]
      ,[StoredValueCardID]
      ,[StoredValueCardType]
      ,[DetailPostingTime]
      ,[DetailLink]
      ,[TaxForgivenTotal]
  FROM [MCRSPOS].[microsdb].[CHECK_DETAIL]

 

[Tombodacious]

Fantastic, thanks for the info! If you don't mind I may reach out to you with some questions when I'm on property with them next week.

 

[Tombodacious]

Moregelen, thanks for your help before, not sure if you're still out there with some simphony knowledge to share. My client asked me to do some work with group types of his sales and the way strings are stored within simphony are nice and fun as I'm sure you know. I'm trying to find the tables to join together to get the sales types (food/liquor/beer/wine/etc) and feel that it should be either the major groups or the family that puts all of this together but can't seem to find any way to link back to any categories. Would you happen to know how to do this?
Thanks,
-Tom

 

[Mauriciose]

Hi Tom, usually you can join with menú_item_class. Join Menu_Item_Master with this table, and you will have the key to join with MAJOR and FAMILY GROUPS tables.

Mauro

 

[Tombodacious]

Thanks Mauro,
I believe I was able to figure it out. The issue I was having revolved around getting the strings related to the major/family and I was looking at it the wrong way, thinking I had to get the hierarchy and object and join that to string numbers instead of the nameID.