Skip to main content

Tyler Odyssey / Enterprise Justice (SFTP)

This integration connects Tyler Technologies' Odyssey or Enterprise Justice case management system with eCourtDate using scheduled SFTP file transfers. It automates the flow of hearing and party data into eCourtDate so agencies can send court date reminders and other notifications without manual data entry.

How It Works​

  1. Nightly report generation — Odyssey generates an Electronic Custom Report (ECR) containing upcoming court dates, party details, and contact information.
  2. Secure file transfer — The report is transferred to an eCourtDate-managed SFTP server hosted in AWS GovCloud.
  3. Automatic processing — eCourtDate retrieves the file, maps columns using an Upload Template, and creates or updates Clients, Events, Contacts, and Cases.
  4. Automated messaging — Notifications (hearing reminders, payment alerts, etc.) are sent based on the agency's configured messaging flows and templates.

Data Included​

The standard ECR report includes the following fields. Your agency can request additional fields from Tyler Technologies depending on your reporting needs.

FieldDescription
Party IDUnique identifier for the party in Odyssey.
First Name / Last NameParty name.
Party DescriptionRole in the case (defendant, witness, attorney, etc.).
Preferred LanguageLanguage preference for notifications.
Phone / EmailContact information for message delivery.
Event Date and TimeScheduled hearing date and time.
Event StatusCurrent status of the hearing.
Location NameWhere the hearing takes place.
Judge NameAssigned judge.
Case NumberOfficial case number.

Including Additional Data​

If your agency needs to notify attorneys, bond agents, or other parties — or needs to include payment details or additional case information — you can:

  • Request a custom ECR from Tyler Technologies that includes the additional fields.
  • Supplement the SFTP integration with manual Console uploads or the REST API for data not available in the ECR.

Prerequisites​

Before setting up this integration:

  1. Confirm ECR availability — Contact your Tyler Technologies Client Success Manager to verify that the Electronic Custom Report is available for your Odyssey or Enterprise Justice instance. Tyler Technologies may charge separately for enabling the report.
  2. Confirm SFTP access — Ensure your agency has SFTP credentials provisioned in eCourtDate. See SFTP Setup for details.

Setup Steps​

  1. Request the ECR from Tyler Technologies. Confirm the report format and included fields with your Tyler representative.
  2. Create a staging agency in eCourtDate (if you do not already have one) to test the integration safely. See Staging and Production.
  3. Configure an Upload Template in the Console that maps the ECR columns to eCourtDate fields (Client, Event, Contact, Case).
  4. Transfer a test file to the eCourtDate SFTP server and verify that records are created correctly in the staging agency.
  5. Configure messaging flows to generate the notifications you want (hearing reminders, payment alerts, etc.).
  6. Review generated messages in the Console before enabling delivery.
  7. Go live — Once validated in staging, replicate the configuration in your production agency and enable the nightly transfer schedule.

Upload Frequency​

The standard integration runs nightly. If your agency needs more frequent updates, consider supplementing with the API-based integration, which supports hourly syncs.

Manual Upload Option​

If your agency has limited IT resources or prefers not to automate the file transfer, staff can manually download the ECR report from Odyssey and upload it through the Console. The same Upload Template processes the file regardless of how it reaches eCourtDate.

Frequently Asked Questions​

Can the report be sent more frequently for real-time updates? For real-time or near-real-time updates, eCourtDate recommends the API-based integration instead. The SFTP method is designed for batch processing on a nightly schedule.

Does eCourtDate write data back to Odyssey? No. This is a unidirectional integration. Data flows from Odyssey into eCourtDate. eCourtDate does not create or modify records in the CMS.

What file formats are supported? The ECR is typically delivered as a CSV or pipe-delimited text file. eCourtDate Upload Templates support CSV, TXT, and XLSX formats. See SFTP File Naming for naming conventions.

How long does setup take? Setup time depends on ECR availability from Tyler Technologies and your agency's SFTP configuration. Once the report is available and SFTP is configured, the eCourtDate side of the integration can typically be completed in a single session.