Skip to main content

DataSources

DataSources​

IntelliBuddies offers a Datasource node to create and manage external data sources in its interface.

Datasource open

Users can configure connections to the following data sources using this tool.

Datasource type

  • Choose the appropriate connection from the configured Connections.

  • Choose the appropriate Lists that you have created with a custom table with a user-defined schema.

Adding New DataSource​

  • To add a new datasource right click on the Datasource node in the Project Explorer Panel and click on menu option Add Datasource.

  • Select Connection dialog appears.

    Add Datasource

  • DataSource Type - Choose the appropriate DataSource Type from the drop down.

    • Creating List Datasource Type

      Add Datasource

    • Creating Connection Datasource Type

      Add Datasource

      TypeDescription
      ListsIt is a custom table with a user-defined schema created inside the Control Room. It will show all the Lists in the Control Room
      ConnectionsIt is a library of credentials to establish authentication for direct communication between IntelliBuddies and an external system. It will show all the configured Connections in the Control Room.

  • You will see the Source option when you select the Datasource Type.

  • Source - Lists the respective Datasources available in the Control Room based on the Datasource Type selection.

  • The following options will be displayed when selecting the Connections Datasource Type.

    • Schema - It lists all the existing schemas in the selected Connection.
    • Table lists all the Tables in the chosen Connection with the selected schema.

  • Name - By default, it sets the table name in case of Connection and the List name in case of Control Room List.

  • Click 'Next' after configuring the page. The second page will display all columns in the selected list or table.

  • We can select only the necessary columns from the DataSource.

  • Click the Save button after selecting the required columns.

  • Once saved, the DataSource will be accessible in the DataSources node.

Editing a DataSource​

Add Datasource

  • To edit the datasource right click on the Datasource to edit in the Project Explorer Panel under DataSource node and click on menu option Edit DataSource. To edit a data source, right-click on the DataSource in the Project Explorer Panel under the DataSource node and select Edit DataSource.
  • Select Connection dialog appears.
  • You can adjust settings to meet your specific needs and save them.

Deleting a DataSource​

Add Datasource

  • Select and right click on the DataSource to delete in the Project Explorer Panel under DataSource node and click on menu option Delete DataSource.
  • Deletes the selected data source.

Binding the DataSource​

You can bind configured data sources for the following