HDMS Wiki Home

  • ExportDataFromBiotics
    		•  Last edited by maggie_woo on Jan 16, 2004 1:34 pm

    Final Export: Biotics 3.1 data

    This page helps you get the Biotics 3.1 Oracle data out to support the BCD2HDMS Data Conversion (of the BCD data) into Biotics 4

    Steps to get data out of BIOTICS 3.1 to support BCD2HDMS conversion. This is required of any "real" conversion of BCD data to HDMS (in which a BIOTICS 3.1 application is an integral part). If the BCD in question does not have a BIOTICS 3.1 application, this step is not necessary. In addition, if the conversion is a "convenience" conversion (e.g., converting BCD data to HDMS for data exchange), it is not necessary to execute this step.

    1. First, open a text editor and retrieve arev\hdms\java\biotics_connection.xml
    2. Next, open a text editor and retrieve the tnsnames.ora file (you can find it under Ora81/network/admin wherever you installed Oracle, or do a search for the file).
    3. Edit the biotics_connection.xml file by replacing the items in the curly brackets with the correct details from the entry for your BIOTICS database in the tnsnames.ora file:

      4. <DB_Connection_info>
  <!-- replace items inside curly brackets-->
  <url>jdbc:oracle:thin:@{host}:{port1521}:{sid}</url>
  <userid>{userid}</userid> 
  <passwd>{passwd}</passwd> 
  <jdbcDriver>oracle.jdbc.driver.OracleDriver</jdbcDriver> 
</DB_Connection_info>

      • {host} = hostname [in Oracle Net8Assistant, this is in the Address Configuration section]
      • {port1521} = port (change to "1521" first, and if that fails, try "1522") [in Oracle Net8Assistant, this is in the Address Configuration section]
      • {sid} service name [in Oracle Net8Assistant, this is in the Service Identification section]
      • {userid} stands for the oracle user ID (e.g., "BIOTICS")
      • {passwd} stands for the oracle password

      For example, see the following tnsnames.ora entry (totally bogus, but serves as an example here): 

      BTEST.ABI.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bioticstest)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = btest)
    )
  )

      Given the example above, the edits would appear as follows: 

      <DB_Connection_info>
<!-- replace items inside curly brackets
-->
<url>jdbc:oracle:thin:@bioticstest:1521:btest</url> 
<userid>my_userid</userid> 
<passwd>my_password</passwd> 
<jdbcDriver>oracle.jdbc.driver.OracleDriver</jdbcDriver> 
</DB_Connection_info>

    4. After you save your changes to the biotics_connection.xml file, double-click on arev\hdms\java\biotics_dump.bat

    5. Note: If the SID is not in the service identification log ask your DBA for the SID of the database or log into sqlplus as the system user and type the command:
      SELECT instance_name FROM v$instance

      This will return the SID of the database.

    [PENDING: There is an even better program for dumping data from another database. It has been tested fully.

    Note updated 2002-11-10: The program mentioned above may be deployed after the Data Exchange Tools are completed and tested. The primary benefit of the updated version is greater flexibility to export data from any ODBC data source into any data format (HDMS-XML or BCD-XML).

    Note updated 2003-01-13: The program mentioned above requires J2RE 1.4.1_01 or higher--this could present a problem for some laptops. It will not be deployed with this conversion package until after the Ecology Pilot Conversion proves it as a viable resource for converting from non-BCD Systems.]

    Back to RunningTheDumpForAnNHP