Connect Oracle E-Business Suite to Vertica, MySQL and other non Oracle databasesBy Alexander Pavlik|September 19th, 2020| Introduction 1 Install Oracle Database Gateway for ODBC 1.1 Reference 1.2 Download Gateway Installer 1.3 Install Gateway 1.4 Create a Gateway Environment File 2 Install the unixODBC Driver Manager on the Gateway Server 3 Configure Connection to a Vertica Database 3.1 Importing a Vertica [...]
Accessing external data sources with Blitz Report™By Geoff Skerrett|July 21st, 2020| Can I access external databases with Blitz Report? The short answer: Yes you can! 1 Creating a Remote Database Connection - Database Links 2 Accessing Data Through a Database Link 3 Performance Considerations 4 SQL Query from Remote Tables or Functions Only 5 SQL [...]
