DataSync is the easiest way to get fresh, up-to-date container and shipment data into your system. DataSync will create 3 tables in your system, in the schema / dataset / folder / spreadsheet of your choice: containers, shipments, and tracking_requests. In addition to these 3 tables, a technical table named _transfer_status is also created, which tells you when each table was last refreshed. We can send the data to almost any database, data warehouse, or object store, as well as to Google Sheets. See the full list of supported systems.

​
How often does the data update?

DataSync will keep the data tables updated with a refresh every hour. Each refresh reloads only the rows that have been changed since the previous refresh, so you won’t have excess writes to your system. To check when a table was last updated, check the _transfer_status table - for each row in that table there is a unique table key, and the time when the latest sync occurred for that table.

​
How to use the data

You can use the container and shipment tracking data any way you like, but here are a couple ideas:
  • Send data directly to your visualization/analytics/reports software like PowerBI or Tableau
  • Send data directly to your TMS or ERP
  • Join data with one of your own tables
  • Use a Database View or Pivot Table to narrow down what you’re looking at, or rename columns
  • Use Database Triggers to respond to updates

​
The setup process

For users that are already tracking shipments with Terminal49, the setup is a 3-step process that takes less than 2 hours on average. Some simpler setups are done in 20 minutes. See below for ways to get data into the system.
  1. Connect data systems. This could mean doing role-based auth or sharing credentials for a single-purpose user. See our security FAQ if you want to know more about how we keep your data secure.
  2. 1-hour configuration call. We make sure you’re getting data the way you want, configuring it to fit in with how you store all your current data.
  3. Start querying the data. And then you’re ready to go! Nothing new to learn - use the tools you already know, now with more data.
Schedule a call with our Customer Success team now to get started.

​
How to start tracking shipments

There are many ways you can start tracking shipments with Terminal49. They all require that you have the Booking Number or Master Bill of Lading number for the shipments you want to track.

​
Getting Started

Schedule your call now! For current Terminal49 customers, schedule a call with our Customer Support team we’ll get you set up. If you’re not yet a customer, schedule a demo with our sales team - they’ll help you find the solution that’s best for you.