Skip to main content

Documentation Index

Fetch the complete documentation index at: https://terminal49.com/docs/llms.txt

Use this file to discover all available pages before exploring further.

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 the security FAQ for more on how Terminal49 keeps your data secure.
  2. 1-hour configuration call. Terminal49 makes sure you’re getting data the way you want, configuring it to fit 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 the Terminal49 Customer Success team 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 the Terminal49 Customer Support team to get set up. If you’re not yet a customer, schedule a demo with the Terminal49 sales team — they’ll help you find the solution that’s best for you.