Querying SQL Server from OBIEE running on Unix
Step-by-step guide to configure OBIEE on Unix/Linux to connect to and query a Microsoft SQL Server database using ODBC drivers.
Robin Moffatt is a Principal DevEx Engineer and seasoned conference speaker with 15+ years of experience presenting at top events like QCon, Devoxx, Kafka Summit, and Strata. He shares insights on developer experience, distributed systems, and cloud technologies through his blog, YouTube, and public talks.
625 articles from this blog
Step-by-step guide to configure OBIEE on Unix/Linux to connect to and query a Microsoft SQL Server database using ODBC drivers.
A technical guide on configuring Oracle BI Presentation Services (sawserver) logging to capture specific activity types and output them to separate files.
A technical guide on using LoadRunner for performance testing OBIEE dashboards, covering script creation, validation, and troubleshooting.
Explains how to configure Oracle BI sawserver logs to use a 'short' format for easier debugging and troubleshooting.
A tip for Oracle Technology Network (OTN) forum users to reduce frequent login prompts by using a specific URL format.
Unix shell scripts to monitor the status of OBIEE and OBIA (Oracle Business Intelligence) server processes, including BI Server, Presentation Server, and Informatica.
A developer shares initial frustrations and technical details while upgrading Oracle BI Applications from version 7.9.5 to 7.9.6.
Troubleshooting guide for an Oracle BI Applications (OBIA) repository connection error caused by incorrect service mode.
Troubleshooting guide for enabling Enterprise Manager after a clean install of Oracle Application Server (OAS).
A technical comparison of Google and Bing search results for a specific OBIEE/ODBC error, highlighting indexing speed and result relevance.
A developer's rant about confusing terminology and unclear upgrade steps in Oracle BI Applications (OBIA) documentation.
Explains Oracle Business Intelligence Applications (OBIA) and its relationship to OBIEE, addressing common confusion in the Oracle BI toolset.
Guide to monitoring OBIEE performance using jManage, an open-source JMX management console, for accessing Java MBeans.
A technical guide on using the HttpFox Firefox add-on to identify the web application server running Oracle BI Presentation Services.
Explores Paul Graham's concept of the conflicting time management needs of makers (developers) and managers in the workplace.
Explains and solves the Oracle SQL error ORA-00922 when changing a user password, highlighting the need to quote passwords starting with numbers.
Guide on using Windows PerfMon to monitor Oracle BI Enterprise Edition (OBIEE) server performance counters for analysis and alerting.
A technical walkthrough of configuring and troubleshooting Mark Rittman's OBIEE repository for querying DAC metadata, including RPD modifications and connection issues.
A guide to using the psservice command-line tool for managing Windows services, with examples for Oracle BI services.
A developer investigates a sawserver crash in OBIEE when rendering charts with large datasets, detailing debugging steps and error logs.