Data integration tools and training

Using custom applications or integration code to allow systems to exchange data, seek to deploy, or enhance IT systems to support and streamline business processes.


Things to consider first

|

Before developing and using data integration tools, consider the business problem you are trying to solve. Then determine which technology best addresses that problem.

University data is more than just spreadsheets and presentations – it’s information gathered about students, academics, budgets, human resources, research, and facilities.

Each of these domains have their own stewards and policies following institutional or legal standards. This is also known as data governance.

Each new tool that connects to university data also needs to be secure, which means it’s possible that it will need to be reviewed by Cybersecurity to see what risk might be involved.

Each tool poses a potential security risk and may need to go through a Risk Management Framework with the campus cybersecurity team.

All tools will need to be secure and not expose campus to any unintended issues. Whether you discover a new tool, or select a pre-approved everyday data tool, there is help available to strategize and identify any red flags or concerns.

In order to be good stewards of university resources, it’s good practice to see if there is an existing solution first.  It can save time and money.

Once a tool has been approved, there is still planning needed to ensure its continued success. Conversations should also take place about:

  • Training
  • Maintenance
  • Who will support the new tool

If you are considering adding a new product or tool, digital accessibility should be part of the decision making process.

To create and run great interoperable experiences, follow the established 12 principles that include things like:

  • Understand users and their needs
  • Solve whole problems
  • Provide cohesive experiences
  • Make sure everyone can use it

Common use cases

API: Application Programming Interfaces

Connecting third party tools to UW institutional data

Syncing a database to a third-party cloud service

Provisioning and deprovisioning

Creating and managing groups

User account management

Data integration tools

These data integration tools are available for your use.
Explore to learn more and then contact an expert to get started.

Cloud-based data integration between systems and applications.

Informatica

Design, secure, analyze, and scale APIs anywhere with visibility and control.

Automate access privileges; manage groups of users to provision access.

UW-Madison logo

Training

In most cases the training available is through the vendor’s own knowledgebase or documentation.