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.

  • herescunty@lemmy.world
    link
    fedilink
    arrow-up
    4
    ·
    edit-2
    4 months ago

    Look into restful api’s. Every software provider that allows integration with another software product will provide an api for other software to communicate in defined ways.

    For bonus credit, look into graphql. It’s a type of api that allows the calling software to define exactly what data they want in the response.

    If you’re controlling both softwares (I.e. they’re two “internal” programs), look into RabbitMQ. It’s a messaging software that allows messages (data) to be passed between two distinct programs in a normalised fashion.

    Disclaimer: this is all off the top of my head early on a Monday morning. Excuse any mistakes.

    • sleepingoddishOP
      link
      fedilink
      English
      arrow-up
      2
      ·
      4 months ago

      Thanks for the suggestions. It sounds like learning all about REST is a good place to start.

      Some of the integration situations I might face is where one software is internal on-prem but the other software is more cloud-based and debatable on how much control we have on our stuff in it.

  • rbn@feddit.ch
    link
    fedilink
    arrow-up
    4
    ·
    edit-2
    4 months ago

    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.

    • sleepingoddishOP
      link
      fedilink
      English
      arrow-up
      1
      ·
      4 months ago

      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?

      • rbn@feddit.ch
        link
        fedilink
        arrow-up
        1
        ·
        4 months ago

        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.

  • silas@programming.dev
    link
    fedilink
    English
    arrow-up
    1
    ·
    4 months ago

    I know this community is for programming, but you could use a tool like n8n as a shortcut to connect services. It’s more of a drag-and-drop node grid similar to Zapier, but it’s open-source and self-hostable. You can schedule tasks to run at a certain time, code your own integrations, or install plugins that other people have made

    • LinearArray@programming.dev
      link
      fedilink
      English
      arrow-up
      1
      ·
      4 months ago

      This is a pretty no-code approach, it’s the way you want to go when you don’t want to write code or build anything by yourself.