2. Add source to bridge

InfoBridge offers powerful data integration. It allows you to import and consolidate data from various sources, including Lumel EPM planning sheets, CSV, Excel, JSON, and Parquet files, as well as online services such as Power BI*, OneDrive, and files via HTTPS.

Adding heterogeneous source to Infobridge

1. Add Planning Sheet to the Bridge

You can add a planning sheet to the bridge in two ways: from the report or the console.

1.1. From the report

When you are working on a report and want to add it to a bridge for integration or transformation, you can follow these steps.

STEP 1: Click Add Source to Bridge in the InfoBridge tab.

Add Source to Bridge

STEP 2: From the pop-up, use the lookup folder or type in the bridge ID to select the bridge to which you want to add the report.

a) Using the lookup folder/search box

You can search for the required bridge using the lookup folder or search box.

Find the bridge in the lookup folder

Select the required bridge in the lookup folder, view the bridge details, and then click Add to import the report into the bridge.

Add to bridge

The source is added to the bridge as Query 2 since the bridge already has a query from Source 1. Click Apply to save changes.

Second source added to bridge

b) Using Bridge ID

If you know the bridge ID, you can directly enter it in the Bridge ID text box.

Using Bridge ID

Copy the bridge ID here.

Copy Bridge ID

Paste the bridge ID in the text box below. Verify the bridge details and click Add.

Add source to bridge

The source is added to the bridge.

Source added to bridge

2. Add other sources to the bridge

You can also import Excel, CSV, JSON, Parquet, and OneDrive/SharePoint files to the bridge from the console.

STEP 1: In the InfoBridge console, select the bridge where you wish to add the source.

Select bridge from the Infobridge console

STEP 2: Click Add Source from the toolbar or the working area (in case you are adding the first source).

Add Source

STEP 3: In the pop-up window, choose the type of source file that you want to add.

File sources

2.1. File sources

They are listed under 'File' section.

File sources supported

STEP 1: Choose the type of file and click Next.

Select file

STEP 2: You can either link the file using the file path/URL or upload it using the drag-and-drop option.

Link or upload the file

STEP 3: After selecting the source file, click Add to import it.

Add source

2.2. Online Services

STEP 1: To add files from online services, select the type and click Next.

STEP 2: Enter the URL of the file and click Add.

Add source from online service