Transcript BBj ODBC Tutorial

Created By: Jeremy Callan
Descore Inc.
905-470-4033 ext. 5405
[email protected]
Table of Contents
Contents
Slide Number
Introduction
3
Download
5
Installation
8
Enterprise Manager Setup
10
Adding a Data Source
13
Viewing Data (EXCEL demo)
18
Introduction
 The BBj ODBC driver is the latest ODBC driver offered
by BASIS International
 The BBj ODBC driver offers a great performance
improvement over the older BASIS ODBC driver
 The BBj ODBC driver is used for third party
applications (such as Microsoft Excel or Access) to
access BASIS data (I.E. MKEYED files)
 To run the BBj ODBC driver, you need a BBj license
(you no longer need a specific ODBC license)
Download
 To download the BBj ODBC driver, you must download
BBj
 In fact, the BBj ODBC driver is an optional download
component in the BBj download
 To download BBj, click here:
https://www.basis.com/products/bbj/download.html
 Select your release
 Select your platform
 Ensure that both BBj and ODBC are selected
Download (con’t)
 Fill in the user information as required
 Click on the needed checkboxes
 Click on the “Download Product” button
Installation
 After downloading the jar file, the next step is
installation
 If you need assistance installing BBj, please refer to the
installation documentation provided online:
http://www.basis.com/onlinedocs/documentation/wi
ninst/installing_bbj5x_windows.htm
Enterprise Manager Setup
 In order to create a new data source, we first have to
setup the data source in the Enterprise Manager
 Launch the Enterprise Manager by clicking on
Enterprise Manager from the BBj folder (from the
BASIS folder)
 The default login/password is: admin/admin123
Enterprise Manager Setup (con’t)
 More information on attaching or adding a
new database to the Enterprise Manger
found here:
http://www.basis.com/onlinedocs/docume
ntation/b3odbc/managing_databases.htm
 The list of databases appears in the bottom
left portion of the Enterprise Manager, and
should look similar to the image on the
right hand side (for BBj installs at rev 8.xx
or higher)
Adding a Data Source
 To add a data source, go to the ODBC administration
page
 This is generally found in Windows by going to:
Control Panel -> Admin Tools -> Data Sources (ODBC)
 Alternatively, the ODBC administration section can be
found here:
C:\Windows\system32\odbcad32.exe
Adding a Data Source (con’t)
 First, click on the “Add...” button
 Then, chose the BBj ODBC driver
 Note, do not select the BASIS ODBC driver
Adding a Data Source (con’t)
 Create a name and a description
for the data source
 In the server field, enter the
name of the server running the
Enterprise Manager where the
database is defined
 The database field needs to be
specified exactly how it appears
in the Enterprise Manager
 The login and password is the
login and password used to log
into the Enterprise Manager
Adding a Data Source (con’t)
 More information on adding a data source can be
found on the BASIS documentation webpage:
http://www.basis.com/onlinedocs/documentation/b3
odbc/create_sysr_user_ds_winodbc_admin.htm
Excel demo
Viewing Data
 After you create the data source, you can view the data
using any third party ODBC compliant application
 In this tutorial we are going to use Excel 2007 to view
the data
Viewing Data (con’t)
 Click on the Data tab and select From Other Sources ->
From Microsoft Query
Viewing Data (con’t)
 Choose the Data Source that was just created
Viewing Data (con’t)
 Choose the tables and columns that you want to view
Viewing Data (con’t)
 Select any potential filtering needed
Viewing Data (con’t)
 Select any needed sorting
Viewing Data (con’t)
 Choose what you want to do with the data
Viewing Data (con’t)
 Select how you want to import the data
Viewing Data (con’t)
 View the data in Excel