bbj odbc tutorial n.
Skip this Video
Loading SlideShow in 5 Seconds..
BBj ODBC Tutorial PowerPoint Presentation
Download Presentation
BBj ODBC Tutorial

Loading in 2 Seconds...

play fullscreen
1 / 28

BBj ODBC Tutorial - PowerPoint PPT Presentation

  • Uploaded on

BBj ODBC Tutorial. Created By: Jeremy Callan Descore Inc. 905-470-4033 ext. 5405 Table of Contents. Introduction. Introduction. The BBj ODBC driver is the latest ODBC driver offered by BASIS International

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'BBj ODBC Tutorial' - cambria-jovan

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
bbj odbc tutorial

BBj ODBC Tutorial

Created By: Jeremy Callan

Descore Inc.

905-470-4033 ext. 5405

  • 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)
  • 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:
    • Select your release
    • Select your platform
    • Ensure that both BBj and ODBC are selected
download con t
Download (con’t)
  • Fill in the user information as required
  • Click on the needed checkboxes
  • Click on the “Download Product” button
  • After downloading the jar file, the next step is installation
  • If you need assistance installing BBj, please refer to the installation documentation provided online:
enterprise manager setup1
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
Enterprise Manager Setup (con’t)
  • More information on attaching or adding a new database to the Enterprise Manger found here:
  • 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 source1
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
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 t1
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 t2
Adding a Data Source (con’t)
  • More information on adding a data source can be found on the BASIS documentation webpage:
viewing data
Viewing Data

Excel demo

viewing data1
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
Viewing Data (con’t)
  • Click on the Data tab and select From Other Sources -> From Microsoft Query
viewing data con t1
Viewing Data (con’t)
  • Choose the Data Source that was just created
viewing data con t2
Viewing Data (con’t)
  • Choose the tables and columns that you want to view
viewing data con t3
Viewing Data (con’t)
  • Select any potential filtering needed
viewing data con t4
Viewing Data (con’t)
  • Select any needed sorting
viewing data con t5
Viewing Data (con’t)
  • Choose what you want to do with the data
viewing data con t6
Viewing Data (con’t)
  • Select how you want to import the data
viewing data con t7
Viewing Data (con’t)
  • View the data in Excel