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]}