BizOne modernized Östgötatrafiken’s Data warhouse by migrating to serverless architecture on Microsoft Azure.
Östgötatrafiken plans and coordinates public transport in Östergötland, Sweden. In addition, they are responsible for travel and hospital transfer services in eight of the county municipalities.
Östgötatrafiken owns only the commuter trains and there vehicles are owned by transport companies that have won the procurements and are driven on behalf of Östgötatrafiken.
Book a one-hour free consultation
has worked as a business developer at Östgötatrafiken since February 2018. She also works as a management manager for the organizationbusiness system, where data storage is included.
Here she tells us about the migration of data from the previous data warehouse solution to the cloud.
A large part of our data storage is used for traffic planning – buses, trams, commuter trains and archipelago traffic. We collect data to be able to control traffic and to make line analysis. The other major part is the system that we use for booking travel services and health travel. There, we also collect a lot of data so that we can follow up costs and cancellations and the like on behalf of the municipalities.
Then we also have more generic data such as customer issues, sales, revenues and traffic costs.
We do not control the traffic ourselves, we buy in services from different traffic companies so that the follow-up also needs to be done.
Since 2009, we had a data warehouse at BizOne in their own data center. However, the solution was approaching a technical end-of-life and we needed to look at alternatives. BizOne recommended a move to Microsoft Azure. Östgötatrafiken has as a long-term strategy to move suitable part of the organization to the cloud and we wanted to be able to collect more data from the traffic. The cloud makes it easier for us to save and analyze larger amounts of data. In parallel, we had already moved other parts to Azure so there was nothing we felt any concern about.
Once we had agreed a solution with BizOne, the implementation went smoothly. While we worked in parallel with the old data-store we noticed almost nothing at all, they took responsibility for the whole migration. The only real difference for us was that the data storage was moved from one hall to another.We have had a great collaboration with Håkan Bellarp who is our main contact person at BizOne.
BizOne recommended a modern cloud-based architecture that benefits from all the features of the cloud. The solution is integrated with Active Directory, and is only accessible from within Östgötatrafiken's network.
All ETL was moved to Azure Data Factory and the database was moved to Azure SQL Database. In the future, BizOne will possibly also help Östgötatrafiken with a solution for manual files, using Sharepoint online and Data Factory.
BizOne took a total responsibility for the migration, at a fixed price, where all existing integrations were moved, ensuring the performance and the basic load solution. Östgötatrafiken has about ten different source systems, with different load frequencies, from daily, hourly to several times per hour. The data was migrated to the cloud over a preriod four months.
BizOne took a total responsibility for the migration, at a fixed price, where all existing integrations were moved, ensuring the performance and the basic load solution. Östgötatrafiken has about ten different source systems, with different load frequencies, from daily, hourly to several times per hour. The data was migrated to the cloud over a preriod four months.
Menu bar
Stockholm - Sweden
Norrköping - Sweden
Bangkok - Thailand
