Open Business Data Fabric (OBDF) Connectivity

Overview

Note: OBDF formerly known as Platform Data Sharing (PDS).

System Administrators can now seamlessly import business views from various data sources into Bizview using the OBDF Connector.

Open Business Data Fabric enables Bizview to function as both a data provider and consumer, facilitating the sharing of planning data with other ISW products like Spreadsheet Server and CDM through a connection in Angles. It also allows the retrieval of data from external sources such as SAP and Microsoft Dynamics 365, and enables importing Business views from Angles using the OBDF connector

By connecting Bizview with Spreadsheet Server, businesses can utilize their Bizview planning data directly within Excel.

Bizview can import pre-built Business views offered by Angles and built the planning solutions.

Additionally, businesses can utilize Bizview's planning data within Angles, allowing them to create, and share rich, highly interactive operational reports and dashboards, without depending on IT.

This enhancement enables the importation of diverse Business Views from multiple ERPs (connections) within Angles. After the import process, Bizview generates a log that details which Business Views were successfully imported and provides a list of any that encountered issues during the import.

Prerequisites

• Active Platform subscription with valid user access
• Angles Professional Connector Admin license
• Bizview version 24.1.0.0 or higher

Import Data via OBDF

1. Navigate to System > Platform Services > select Import Data via OBDF.

   

   The Import Data via OBDF window pops up.

2. Select Import Data via OBDF to continue.

   

   The Select Business Views to be imported window pops up.

3. Choose the desired ERP connection from the ERP Data Source dropdown.

   

4. Select one or more Business Views from the Business Views dropdown. v25.3.0.2: 

   

5. Enter the Pagination Limit between 1 and 100000.

6. Click Import to begin the process.

   The system begins the import and displays a progress indicator below the import text with a loading spinner.

   The progress indicator displays the following information:[v26.1] 

   

   Information	Description
   Rows imported	The current number of rows imported versus the total expected rows (for example, “3,245 of 10,000 rows imported”).
   Percentage	The percentage of completion (for example, “32%”).
   Progress bar	A visual progress bar representing the import completion status.

   The counter updates continuously as rows are processed.

   Note: If the import fails, the system displays the last successfully imported row count along with the failure message.

7. Upon completion, the imported Business Views are stored in the Bizview database within the custstg table schema.

   A detailed log displays showing which Business Views were successfully imported.

   

OBDF Data Import Settings [v26.1] 

Starting from version 26.1, a new OBDF Data Import Settings page is available under Platform Services.

You can configure timeout values for both manual OBDF data imports and OBDF Plugin imports to optimize performance based on dataset size and network conditions. 

This eliminates the need for manual database or configuration file editing.

Navigate to System > Platform Services > OBDF Data Import Settings.

To configure OBDF Data Import timeout settings:

1. Navigate to System > Platform Services > OBDF Data Import Settings.

   The OBDF Data Import Settings page opens with a Close button at the top and two configuration sections.

2. Configure the timeout values for each section as described below.

   Manual OBDF Data Import Timeout Settings: 

   Field	Description
   HTTP Client Timeout (seconds)	Maximum duration for HTTP-based data transfer operations. Numeric input. Default: 1800. Range: 60–7200.
   SQL Bulk Copy Timeout (seconds)	Maximum time allowed for SQL bulk copy operations. Numeric input. Default: 600. Range: 60–3600.

    The HttpClientTimeout and SqlBulkCopyTimeout parameters used for Manual Business Views import via the OBDF connector can also be configured in the pdsConfig.json file. By default, HttpClientTimeout is set to 1800 seconds, and SqlBulkCopyTimeout is set to 600 seconds v25.3.0.2: 

   

   OBDF Plugin Timeout Settings:

   Field	Description
   HTTP Client Timeout (seconds)	Maximum duration for HTTP-based data transfer operations. Numeric input. Default: 1800. Range: 60–7200.
   SQL Bulk Copy Timeout (seconds)	Maximum time allowed for SQL bulk copy operations. Numeric input. Default: 600. Range: 60–3600.

   Note: Hover over the info icon next to each field to view helper text describing the field purpose and default value.

3. Click Save to persist the values to the database.

   The system displays a success notification. If the save fails, an error notification is displayed.

4. To restore factory default values Click Reset Default for the relevant section.

   Note: Input validation prevents non-numeric and out-of-range entries.

Enable data export from Bizview to Angles

Platform users can also export Data Views from Bizview into Angles using the Data API feature.

1. Navigate to Settings > Other > and select Data Api.

   

2. Configure the following fields:

   1. User: Enter the authorized user
   2. Client: Specify the client access
   3. Target: Add the URL to fetch available Business Data Views

   

The system restores the default values: 1800 seconds for HTTP Client Timeout and 600 seconds for SQL Bulk Copy Timeout.