Accessing Biotics 5 via Third-Party Applications and using them

Accessing Biotics via third-party applications, such as: Tora, Toad, SQLDeveloper, Crystal Reports, ArcGIS.

Excel macros for use in formatting batch update spreadsheets
When using an Excel spreadsheet to create batch update statements, string fields must receive special formatting in order to run properly in SQL+. Most no...
Wed, 5 Nov, 2014 at 11:53 AM
HTML Conversion in Crystal Reports
In Crystal Reports you can choose HTML interpretation for a field, and italics, etc. will be rendered properly. It also correctly converts <, &...
Wed, 19 Nov, 2014 at 2:30 PM
Existing Crystal Reports for use
There are a number of standard Crystal Reports already available in the Data Management Community section of the SharePoint site. Within Documents, see Crys...
Thu, 8 Nov, 2018 at 1:09 PM
Connecting via QGIS
The following information (same as used to connect to SQL Developer) was used by R. Ian Horn (KY) to connect to QGIS.
Wed, 6 Jan, 2016 at 7:54 AM
Connecting to Biotics 5 database via SQL Server
Thanks to Rayo McCollough from the New Mexico Natural Heritage Program for providing the following instructions. Requirements: Download and install...
Mon, 29 Feb, 2016 at 2:33 PM
Connecting Oracle SQL Developer to SQL Server database
Thanks to Rayo McCollough from the New Mexico Natural Heritage Program for providing the following instructions. For more information, see http://ww...
Mon, 29 Feb, 2016 at 2:32 PM
Using GeoRaptor to import a shapefile into Biotics in SQL Developer
See the attached instructions provided by R. Ian Horn, Kentucky State Nature Preserves Commission, for installing the GeoRaptor plugin for SQL Devel...
Fri, 8 Jul, 2016 at 9:30 AM
SQLPlus (application) quits when trying to log in or receive SP2-1503 error when logging into SQLPlus via DOS prompt
Problem: SQLPlus just quits when trying to log via the application. Unfortunately, we need to see an error, so log into sqlplus via the DOS pr...
Tue, 15 Nov, 2016 at 11:09 AM
Downloading Survey123 data to file geodatabase via python script, when other methods fail
The attached Python script demonstrates how you can download your Survey123 data into a local shapefile, file geodatabase, or CSV file. To run this script,...
Mon, 17 Jun, 2019 at 11:45 AM
Adding custom Crystal Report to Biotics instance
Open the attached Crystal Report and run it - this will create the datasource connection needed to run successfully from a Biotics server. Open the custom...
Wed, 13 Jan, 2021 at 10:48 AM