Biotics 6 Specific Documentation

Solutions for functionality that differs significantly between Biotics 5 and Biotics 6 (will eventually be moved to online help)

Connecting to the Postgres Database via PgAdmin
To connect to the Biotics 6 database, you will need to download PgAdmin or another Database access tool of your choice. You will also need database access w...
Fri, 4 Sep, 2026 at 1:36 PM
Importing NatureServe Postgres Backups into an Esri SDE Environment
Background As part of the Biotics AWS migration, NatureServe now provides data backups as native Postgres dump files (pg_dump) rather than Oracle-compatibl...
Tue, 25 Aug, 2026 at 12:31 PM
DELIMLIST replacement in B6
Following is an example to pull the list of user groups as found within security_users_vw: ( SELECT string_agg(su.security_users_name::text, ', '::...
Tue, 24 Feb, 2026 at 2:01 PM
Pavel Stehule's blog: fresh dll of orafce and plpgsql_check for PostgreSQL 17 and PostgreSQL 18
Following copied per request in https://natureserve.atlassian.net/browse/BX6-645 should the blog ever go away. fresh dll of orafce and plpgsql_check for Po...
Thu, 16 Jul, 2026 at 9:03 AM
Create the Biotics 6 Database from the Backup
See the attached document for instructions for utilizing the Biotics 6 nightly backup to create the Biotics 6 database.
Tue, 7 Jul, 2026 at 11:42 AM
Connecting Biotics 6 Postgres Databases to Power BI
Overview Member programs and partners can connect Power BI to their Biotics PostgreSQL database for reporting. This works differently depending on whether...
Tue, 15 Sep, 2026 at 5:22 PM