Cloud Database Delivery

Advanced Shipment Data Analytics
Cloud Database Delivery is a ready-to-go database for historical and near-real time* shipment analysis. This dataset is assembled from Union Pacific’s Web Portal, waybills and equipment characteristics (UMLER). The data is in the cloud ready to connect to business integration tools and is available for consumption to AI/ML models. This dataset is analytics ready, saving you complicated ingestion logic and collection of Electronic Data Interface (EDI)/Application Programming Interface (API) messages. 

Technology Match
Cloud data can be accessed by the technology level of choice of the end user.

• A logistics rep working in Excel can directly connect to a cloud database and refresh the spreadsheet with data from Union Pacific.
• A business analysis can set up dashboards and reports from a database connection.
• A software developer can connect to the cloud via a code engine such as Python. The data is also available for AI Agents to deliver supply chain intelligence. 

Cloud Storage Accounts
This is the staging area for large files such as CSV, Parquet or JSON prior to being ingested into a cloud application such as a data warehouse. These storage accounts can be accessed anywhere and are infinitely scalable. If you have a cloud presence today, you likely have a storage account ready to receive data from Union Pacific. 

Typical Requirements
This is a no-code solution through the cloud administrators. The access is setup using the existing user interface of the cloud storage account. Union Pacific supports integrations with majore cloud providers. Following are the technical setup requirements:

• Microsoft Azure: See Instructions
• Amazone AWS: See Instructions
• Google GCP: Contact Union Pacific API Support 

Third-Party Providers
Third-party providers help Union Pacific customers manage their supply chains and cloud databases can make it easier for third-party providers to do that job. Third-parties must have an active Letter of Authority with Union Pacific and agree to Union Pacific rates and terms. Third-party management will be performed by Transcentric. Please contact them directly for more details.

Cloud Data Charges
Customers are responsible for the storage and compute charges assessed by their cloud provider typically based on configuration and use. Union Pacific does not charge any additional fees for cloud data delivery. 

Differences between EDI, API and Cloud Delivery
EDI and API are business-to-business messages. EDI is an older technology and runs over a private VAN whereas API is a newer platform over the secured-public internet. EDI is standardized across the railroad industry and supports car location updates (CLMs), waybills and invoices. API payloads are unique to each railroad. At Union Pacific, we have APIs supporting: Shipment Updates, Shipment Actions, Waybills, UPGo, Gate Reservations and more. Additional details are available on our Developer Center.

The Cloud Database Delivery channel provides a database ready for consumption. Both real-time and historical data are available. Updates are pushed to your storage account in near-real time. The fields available in the cloud are across multiple railroad subject areas, saving the need to develop join logic. Union Pacific has also added additional data elements such as transportation milestones, latitude, longitude and time zone in this channel. 

Platform Comparison Chart

*60-Minute target lag.