Business Intelligence

Tables

  • smart_bi_step The Step related to a record in the table smart_bi_file

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
Run the “Stack Builder” and download and install x64 ODBC
run pgadmin
r-click on databases and create smartbi database
the username is postgres and password of your choice

Column name Table: smart_bi_step
id The id of the Step. Join to this column from [smart_bi_file.step_id] and [smart_bi_session.step_id]
name The name of the the Step
class The class of the Step.
  • 1 = File Management
  • 2 = Data ETL
  • 3 = For-Each
  • 4 = Group
  • 5 = PowerShell
Last modified: 11 November 2025