An established approach for obtaining, converting, storing, and analysing data without the need for human interaction, regardless of the format in which the data is stored.
Data automation is the process of updating data on your open data portal programmatically, rather than manually. Automating the process of data uploading is important for the long-term sustainability of your open data program. Any data that is updated manually risks being delayed because it is one more task an individual has to do as part of the rest of their workload.
There are three common elements to data automation: Extract, Transform, and Load.
Extract: the process of extracting your data from one or many sources systems
Transform: the process of transforming your data into the necessary structure, such as a flat file format like a CSV. This could also include things like changing all state abbreviations to the full state name.
Load: the process of loading the data into the final system, in this case the open data portal.
Each one of these processes is critical to fully automating your data uploads, and doing it successfully.
Have Questions ? Talk to us!
We offer consulting services for companies with IT projects where more hands are needed on, as well as being there with the bulk-buy abilities to giving your team cost-effective tools.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo. luctus nec ullamcorper mattis, pulvinar dapibus leo