Oh jeesh – Have you seen our YouTube channel? Please, for the love of all that is Remedy, have a look by clicking on my little link below. MS Analysis Services is way, way better for automating all of this, not to mention the fact that you can also use Tableau and PowerBI with it. Have a look! http://www.youtube.com/user/northcraftanalytics
Lee Cullom | Northcraft Analytics IT Metrics Specialist | Business Intelligence Applications for IT Direct – 678-438-7244 | http://www.northcraftanalytics.com<http://www.northcraftanalytics.com/> Main - (678) 664-ITSM [cid:image003.jpg@01CD6684.40E6DBC0]<https://www.linkedin.com/company/1747717?trk=tyah&trkInfo=clickedVertical%3Acompany%2Cidx%3A2-1-6%2CtarId%3A1429298510789%2Ctas%3ANorthcraft>[cid:image004.jpg@01CD6684.40E6DBC0]<http://twitter.com/#!/NorthcraftIT>[http://citadel.sjfc.edu/students-virtual/A/act00294/public_html/webdesign/Responsive%20Web%20site/images/youtube.png]<http://youtube.com/user/northcraftanalytics> What is Northcraft Analytics? Find out in 87 Seconds. <http://www.youtube.com/watch?v=SRNyPNK_HJc> From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, November 4, 2016 9:56 AM To: arslist@ARSLIST.ORG Subject: Re: Issue related to 32 Bit AR ODBC Driver ** You are going to need an ODBC to JDBC bridge as Microsoft products do not support JDBC directly Do a Google search on “odbc-jdbc bridge” Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sriram pm Sent: Friday, November 04, 2016 8:51 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Issue related to 32 Bit AR ODBC Driver ** Hi Carina & Mark, I am using Oracle more over remedy credentials is easier to access then to go for an oracle account as we need to request for a service account:(.... which is a tedious process. Since it is Microsoft Share Point I cannot use JDBC Driver. Thank you, Sriram. On Fri, Nov 4, 2016 at 6:51 PM, Burns, Carina <carina.bu...@risd.org<mailto:carina.bu...@risd.org>> wrote: ** What database are you running? Instead of the AR ODBC driver, why not try a 64-bit ODBC driver for the db? I use an oracle odbc driver for my reporting. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of sriram pm Sent: Friday, November 04, 2016 6:11 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Issue related to 32 Bit AR ODBC Driver ** Dear Experts, We have a Dashboard in Share-point which publishes Reports in Excel. We have installed 32 Bit AR ODBC Driver in the Share Point 2013 Server and the report gets refreshed when I run the report in an MS Excel Application but when I access the report using the Browser where the report is published and try to refresh it throws an error as "Unidentified ODBC Driver". We raised a Case with Microsoft and they say that an 64 Bit AR ODBC Driver needs to be installed in the Share Point Server. I am not able to find a 64 Bit AR ODBC Driver. Kindly help in fixing this issue. Thank you, Sriram. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"