I am very new to SQL. The ERP Product is Global Shop Solutions (GSS), a software used for clocking work orders and times. It uses Actian Zen which used to be called Pervasive. I am wanting to query the database remotely so I can eventually view and manage the data in a web app. How can I pull the data into SSMS?
From what I know, I can use OPENQUERY once I have the linked server set up. I know it's possible because I found a post on here of someone with GSS set up with SQL Server.