Linking databases from your library's website

Linking databases from your library's website oplin

OPLIN can provide remote access to nearly any subscription database a library purchases; contact the OPLIN Support Center for more information.

Links for the statewide databases licensed as part of the Ohio Web Library
Database name Correct URL
All EBSCOhost Databases https://ohioweblibrary.org/db/ebsco-all or https://ohioweblibrary.org/db/ebsco-service-select
     Academic Search Premier https://ohioweblibrary.org/db/ebsco-academic
     Alt HealthWatch https://ohioweblibrary.org/db/ebsco-althealthwatch
     Biography Reference Bank https://ohioweblibrary.org/db/ebsco-bios
     Business Source Premier https://ohioweblibrary.org/db/ebsco-business
     Computer Source https://ohioweblibrary.org/db/ebsco-computersource
     Consumer Health Complete https://ohioweblibrary.org/db/ebsco-consumerhealth
     ERIC https://ohioweblibrary.org/db/ebsco-eric
     Explora Primary School http://ohioweblibrary.org/db/ebsco-explora-primary
     Explora Middle School http://ohioweblibrary.org/db/ebsco-explora-middle
     Explora Secondary School http://ohioweblibrary.org/db/ebsco-explora-secondary
     GreenFILE https://ohioweblibrary.org/db/ebsco-greenfile
     Health Source:  
     Consumer Edition
https://ohioweblibrary.org/db/ebsco-healthsource
     Health Source:  
     Nursing/Academic Edition
https://ohioweblibrary.org/db/ebsco-healthsourcenursing
     Hobbies & Crafts Source https://ohioweblibrary.org/db/hobbies
     Home Improvement Source https://ohioweblibrary.org/db/ebsco-home
     Literary Reference Source https://ohioweblibrary.org/db/ebsco-literary
     MAS Ultra - School Edition https://ohioweblibrary.org/db/mas
     MASTERFILE Premier https://ohioweblibrary.org/db/masterfile
     MEDLINE https://ohioweblibrary.org/db/medline
     Middle Search Plus https://ohioweblibrary.org/db/middle
     Newspaper Source https://ohioweblibrary.org/db/newspaper
     Points of View Reference  
     Center
https://ohioweblibrary.org/db/ebsco-viewpoints
     Primary Search https://ohioweblibrary.org/db/primary
     Professional Development  
     Collection
https://ohioweblibrary.org/db/professional
     Psychology and Behavioral  
     Sciences Collection
https://ohioweblibrary.org/db/psychology
     Religion and Philosophy  
     Collection
https://ohioweblibrary.org/db/religion
     Science Reference Source https://ohioweblibrary.org/db/ebsco-scienceref
     Small Business Source https://ohioweblibrary.org/db/ebsco-smallbusiness
     Sociological Collection https://ohioweblibrary.org/db/sociological
     TOPIC Search https://ohioweblibrary.org/db/ebsco-topic
     Vocational and Career  
     Collection
https://ohioweblibrary.org/db/vocational
   
African American Heritage https://ohioweblibrary.org/db/africanamericanheritage
American & English Literature https://ohioweblibrary.org/db/literature
Ancestry Library Edition https://ohioweblibrary.org/db/ancestry
Chilton Library https://ohioweblibrary.org/db/chilton
CultureGrams https://ohioweblibrary.org/db/culturegrams
Fold3 Library Edition https://ohioweblibrary.org/db/fold3
Heritage Quest https://ohioweblibrary.org/db/heritagequest
Oxford Research Encyclopedias https://ohioweblibrary.org/db/oxfordre
Sanborn Fire Insurance Maps https://ohioweblibrary.org/db/sanborn
Very Short Introductions https://ohioweblibrary.org/db/veryshort
All World Book Databases https://ohioweblibrary.org/db/worldbook
     World Book Advanced https://ohioweblibrary.org/db/worldbook-advanced
     World Book Early  
     World of Learning
https://ohioweblibrary.org/db/worldbook-early
     World Book French http://ohioweblibrary.org/db/worldbook-french
     World Book Kids https://ohioweblibrary.org/db/worldbook-kids
     World Book Spanish  
      (Banco de Contenidos aulaPlaneta)
https://ohioweblibrary.org/db/worldbook-his
     World Book Student http://ohioweblibrary.org/db/worldbook-student
     World Book Student-Spanish  
      (Enciclopedia Estudiantil Hallzazgos)
https://www.ohioweblibrary.org/db/worldbook-spa
     World Book Timelines http://ohioweblibrary.org/db/worldbook-timelines

 

General resources provided by OPLIN
Website name Correct URL
Find an Ohio Public Library tool https://www.oplin.org/fal
Ohio Web Library https://www.ohioweblibrary.org
What Tree Is It? https://www.oplin.org/tree
What's That Snake? https://www.oplin.org/snake
What's the Point? https://www.oplin.org/point

 

Get MARC records for your catalog

Get MARC records for your catalog oplin

Some of the Ohio Web Library vendors provide MARC records that can be loaded into a library's catalog, so their online resources will appear in catalog search results. These MARC records will contain a link to the resource in the 856 field of the record (subfield u); however, for people outside the library, these links will not allow access to the resource, because they do not pass through the user authentication associated with our statewide subscriptions.

To fix this, the URLs in the 856 fields must be modified in two ways:

  1. Add this to the beginning of each link:
    https://auth.oplin.org/?url=
  2. Replace every "&" in every link with "%26" (percent-encoded ampersand)

For example, a link to Consumer Reports in the MARC record downloaded from EBSCO might have "https://search.ebscohost.com/direct.asp?db=f5h&jid=%22CRP%22&scope=site" in the 856u tag, and that would need to be changed to "https://auth.oplin.org/?url=https://search.ebscohost.com/direct.asp?db=f5h%26jid=%22CRP%22%26scope=site".

One easy way to make these modifications is to use Terry Reese's MarcEdit tool (free download). Open the MarcEditor, open the file of MARC records downloaded from the vendor, and from the "Tools" menu choose "Edit Subfield Data." In field 856, subfield u, look for field data https:// and replace it with https://auth.oplin.org/?url=https://. Repeat this process, looking for & and replacing it with %26. Save the edited file and it should be ready for importing into your catalog.

The vendors below currently provide MARC records for Ohio Web Library databases:

EBSCO
A large selection of MARC record files can be downloaded from the EBSCO Administrator interface. (If you don't know your login credentials, contact OPLIN Support.) Navigate to "Database Title Lists" and click on the "MARC 21" tab.
World Book
World Book provides some very general MARC records from their Training & Support site.
LinkedIn Learning
LinkedIn Learning MARC records require access to the LinkedIn Learning administrator interface. Contact OPLIN Support for assistance.