Hello,

We are a longtime RMS/Shiprush user, but recently moved to Retail Pro. I would like to continue to use Shiprush as we love the interface. It looks like there's no direct integration, but we are trying the desktop version and connecting to the Oracle database via ODBC. Inside the connection manager I can get a connection to the Oracle db just fine. I have a basic query just to test the connection select CUST_ID from CUSTOMER. This always returns ORA-00942: table or view does not exist. I thought it might be an issue with the query, so I opened Excel on the same computer, used the same DS_REPORTS ODBC connection and looked at the sql statement in there
SELECT CUSTOMER.CUST_ID
FROM CMS.CUSTOMER CUSTOMER

I then pasted this into the query window in Shiprush and I got the same error. I'm not exactly sure where to go from here as it seems isolated to just Shiprush being able to retrieve the data.

Thanks,
David