To download and install BI Publisher desktop for Microsoft Office:
- Download Oracle BI Publisher Desktop for Microsoft Office from: http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html
Ensure that you choose the BI Publisher Desktop version (32bit vs. 64bit) based on your version of Microsoft Office 32 bit or 64 bit.
Tip: If your Microsoft Word executable is found at
C:\Program Files (x86)\Microsoft Office\Office12\WINWORD.EXE, then you have the 32 bit version). - Run the installer.
No additional setup is required after running the installer. To ensure that the installation was successful, check to see that the plug-in has been added to your Microsoft Word user interface. The BI Publisher ribbon appears after launching Microsoft Word.
(Optional) SQL Text Editor
Once you start to write more complex reports, having a text editor that highlights SQL keywords can make a big difference. For your needs, a simple editor such as Notepad++ would suffice. Ensure that you set the Language to SQL. You can copy the queries developed through the text editor and paste them into the Data View window.
(Optional) SQL Developer
You can download Oracle SQL Developer from: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
- Download the first option in the list: Windows 64-bit - zip file includes the JDK 7
- Extract the file onto your computer (for example,
C:\Oracle\sqldeveloper\) - Run sqldeveloper.exe