Connectors

Data Export Use Cases

Archibus Connectors Framework supports these use cases, to export data from the Archibus database to remote databases:

  • Both insert or update data in the remote database.
  • Update only existing data in the remote database.
  • Insert only new data in the remote database.

To configure connectors for each of these use cases, enter one of the following Connector Parameters in the Connector Properties form:

  • For insert or update , enter the following connector parameter:

    {supportInserts:true, supportUpdates:true{color}}

  • For update only , enter the following connector parameter:

    {supportInserts:*false, supportUpdates:*true}

  • For insert only , enter the following connector parameter:

    {supportInserts:true, supportUpdates:false,ignoreSqlErrorCodes:[errorcode]}

For the error code in the insert only case, enter these values for each database server type:

  • For MS-SQL server, enter error code 2627.

    Example: {supportInserts:true, supportUpdates:false,ignoreSqlErrorCodes:[2627]}

  • For ORACLE, enter error code ORA-00001.

    Example: {supportInserts:true, supportUpdates:false,ignoreSqlErrorCodes:[ORA-00001]}