How does BCP integrate with an ERP system or other system of record?
Since BCP is based on a relational database, it is able to communicate bi-directionally with any data source either though an Excel file format, through BCL, or directly using the API or SQL. This data integration is most often treated as another user in BCP. For example, a change coming from Oracle might be the latest “shipped orders” sales information which, once captured by BCP, is then shared with all users interacting with that dataset. BCP also can setup integrations with existing BI vendors where BCP becomes a data source just like SAP or SIEBEL for enterprise data residing in spreadsheets.