I want to learn how to build integrations, such as how to connect two systems made by different companies that have different structures.
For example: To cut down on redundant data entry, I want to build an integration where the data is pushed from one software to another software. The integration would put the data from the source software into the correct fields in the destination software.
How do I go about learning how to build integrations? What classes to even start with?
I appreciate any guidance you can provide.
Edit: Thanks a bunch for the suggestions. I’m checking out those tools suggested in the comments and looking up classes to learn the skills needed.
I’d say that heavily depends on Software A and B.
If you want to actively push data from system A, you need to check for system-specific enhancement options for that system. E.g. is there a way foreseen to add custom plugins, call webhooks, etc.
If you want to actively want to pull data from system B instead, you have to do the same exercise as before but for the other system.
Such interfaces (if available at all) are often vendor specific, so one software may use Java for addons, another only Python etc.
In more complex integration scenarios, you often work with a so-called middleware that acts as a translator between different data formats, protocols etc. Such middleware software often already has pre-built triggers or prepared integration routines for very common software. A commercial example that is mostly meant for end users would be Microsoft Power Flow or if you are looking for FOSS you can check out Node Red.
I don’t think there is a lot of ‘integration knowledge’ that is generally applicable independent of the software in use. If you want to start building a toolbox of skills, you could start looking at SOAP, REST, XML, maybe learn a scripting language such as Python etc.
Thanks a bunch for the suggestions. I think learning the basic toolbox is where I should start, then work my way up to the software-specific interfaces.
Have you ran into software made by companies that didn’t have APIs available or didn’t want their software integrating with other systems? How would you work around that?
For web applications you can often reverse engineer the internal / non-documented APIs using the development tools of your browser or network traffic analysis such as Wireshark. As a last resort for software without APIs you can always use robotics tools and automatically use the GUI as a user would do. You could for example check out the Selenium framework for Java.