Query issue to Oracle database
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
Re: Query issue to Oracle database
It could be related to the user login information you're providing to get connection as well. Or it could be rights related and the user doesn't have rights to access fully.
What is your full connection string? Have you attempted to access using something like query analyzer (aka SQL Server Management Studio)?
SYSOPS
Re: Query issue to Oracle database
Provider=MSDASQL.1;Password=hidden;Persist Security Info=True;User ID=reportuser;Data Source=DS_REPORTS;Mode=Read
Password hidden for security reasons.
I have tried to access it from another computer using Oracle's sqldeveloper and I can get in. I can also get in on this PC via ODBC in excel and get data out.
Re: Query issue to Oracle database
I have our QA team reviewing connecting to an Oracle database. Case 74444. We will update here with more information.
Thank you,
SYSOPS
Re: Query issue to Oracle database
I actually got this to work. I'm not sure what exactly I changed, but the query started to return data from our Retail Pro Oracle installation. I'm not at the store anymore, but I will paste the query used here to potentially save some headaches for another user.
Thanks for the help!
Re: Query issue to Oracle database
Thank you for the update and please do let us know what may have changed in your query.
SYSOPS