Integrating data by using Developer Studio forms


Data integration is the process of collecting data from different sources to form a single unified dataset. With the increasing complexity of data, businesses use data integration to create a secure, reliable, and scalable solution to provide real-time data for reporting and analysis. The data integration tools enable processing and moving data from the source to the destination.

BMC Helix Innovation Suite uses the Developer Studioforms to integrate data with internal and external systems.

Important

The content in this section is recommended for developers, who have a working knowledge of Developer Studio and have access to external databases.

The following image illustrates the process of data integration from many data sources to data visualization:

22_1_integrating_with_dev_studio_forms.png

The following table lists the topics that describe how you can use the Developer Studio forms to integrate data from several data sources and use it multiple reports and formats:

Action

Reference

Use Vendor forms to view and process external data using AR System processes and workflow.

Use View forms to point to and access data in relational database tables outside AR System.

Use SQL database access to enable third-party applications to read data from the AR System database.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*