You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
You are viewing the article in preview mode. It is not live at the moment.
Home > Support Center > SIS Integration > Aeries–SIRAS Integration: Configure and Test Both Data Directions
Aeries–SIRAS Integration: Configure and Test Both Data Directions
print icon
An Aeries–SIRAS integration has two separate data directions.
Aeries → SIRAS uses the Aeries API key to update demographic, enrollment, and contact information in SIRAS.
SIRAS → Aeries uses SIRAS-generated files in the district SFTP folder and the Aeries Special Ed Data Import process.

What do you need to do?

SIRAS path for the Aeries → SIRAS Training test: Tools → SIRAS Admin → Scheduled Task Logs
Contacts identifiedSFTP verifiedAeries API credentialSIRAS Training pullAeries Special Ed ImportTraining/data reviewProduction
Starting from the beginning?
The responsible district contacts should already be identified and the district should be able to connect manually to its SIRAS SFTP folder. If that work is not complete, use SIS Integration: Start Here and SIRAS SFTP: Secure File Exchange & Connection Settings first.

Understand the Two Data Directions

Direction Purpose Connection
Aeries → SIRAS Provides demographic, enrollment, and contact updates to SIRAS. Aeries API. The district creates the Aeries API credential; SIRAS uses it to retrieve data.
SIRAS → Aeries Provides the approved SIRAS Special Ed Data Import files to Aeries. SIRAS creates files in the district SFTP folder; Aeries retrieves them using its Special Ed Data Import configuration.
The SFTP password is used in multiple stages of integration.
A person may first use the district SFTP username/password in an SFTP client to send SIRAS the API credential. Later, the same district SFTP credentials are entered into Aeries so Aeries can retrieve SIRAS-generated SPED data files.

Aeries → SIRAS: Create and Deliver the API Credential

Use Aeries' maintained instructions for the Aeries-side API certificate/key creation and permissions:

Aeries Support — SIRAS Integration

SIRAS documentation does not duplicate vendor-maintained credential-creation steps. After the credential is created:

  1. Save the API credential information in a text file or another secure file format agreed upon with SIRAS.
  2. Upload the credential file to the district's SIRAS SFTP folder.
  3. Do not email the API credential to SIRAS.
  4. Email SIRAS the district's non-secret Aeries login/base URL and tell SIRAS that the credential is available in SFTP.
  5. SIRAS configures the Aeries → SIRAS connection in the Training server.
Complete when: SIRAS can connect to the district Aeries system from Training and retrieve representative demographic/contact data. Then continue to test the Training connection and data.

SIRAS → Aeries: Configure Special Ed Data Import

Use the Aeries documentation as the vendor reference for the Special Ed Data scheduled/manual import feature:

Aeries Support — Special Ed Data Scheduled or Manual Imports

For a SIRAS-hosted integration, use the following SIRAS-specific file-location values in Aeries:

Aeries setting SIRAS-specific instruction
Special Ed files are stored on a Secure FTP Checked / enabled
SFTP connection Use the district's current SIRAS SFTP connection settings. Article 525 owns the host, port, username, password, remote-directory, manual-test, and firewall guidance.
SFTP import directory Leave blank for the standard SIRAS-hosted Aeries integration unless SIRAS has provided a different path for the district.
Data Files Include Student and Services.
Student file name tableA.csv
Services file name tableB.csv
Scheduled days Monday through Friday
Scheduled time Schedule Aeries to import the SIRAS files at 4:00 am so the current tableA.csv and tableB.csv files are available.
Need help with the SFTP connection?
For the current SIRAS SFTP host, port, username convention, password handling, manual connection test, or firewall guidance, use SIRAS SFTP: Secure File Exchange & Connection Settings.
Do not use the one-time/manual import as the first setup step.
Configure the connection, schedule, and responsible email recipients first. Save the one-time/manual import for the final SIRAS → Aeries connection test. The manual import sends the import-log email and also populates/updates Aeries Special Ed data, so it is not a view-only connectivity check.

Configure Completion Emails, Then Run the One-Time Import

Before the final SIRAS → Aeries test, enter the email addresses of the staff responsible for reviewing Aeries Special Ed Data Import results. This normally includes the SEDS Coordinator who sends SPED data to CALPADS from SIRAS and any SIS staff who own the integration.

After the email arrives:
Use Aeries Special Ed Data Import: Read the Completion Email & Reports to learn about the email.
The SIRAS → Aeries connection is verified when:
  • Aeries can reach the SIRAS SFTP location;
  • the current SIRAS files are found and processed;
  • there are no unexpected setup/connection errors; and
  • the responsible contacts receive the Aeries completion/import report email.

Treat this first completion report as the district's first integration-monitoring review. Review the counts, unmatched/actionable items, and unexpected results with SIRAS staff rather than treating “the job ran” as the only success criterion.

Aeries Is Connected to Training — Test the Connection and Data

Use this section when: SIRAS has told you that the Aeries → SIRAS API connection is configured in the Training server and you now need to confirm that the connection is running and the imported data is being interpreted correctly before Production.

SIRAS click path: Tools → SIRAS Admin → Scheduled Task Logs

1. Review the Aeries → SIRAS import evidence

  1. Open Tools → SIRAS Admin → Scheduled Task Logs.
  2. Locate the current Aeries API import run and download the most recent #######__api_Import_log.csv.
  3. Review the log with SIRAS. Confirm that the expected job ran and investigate any unexpected connection, processing, or data errors.
  4. If the SIRAS → Aeries direction is also being tested, compare what you see with the most recent Aeries Special Ed Data Import completion email and reports.

2. Spot-check representative Training records

Do not stop at “the job ran.” Review representative students across different schools, grades, demographic values, and contact situations.

Data to review What to verify
School assignment The student is associated with the expected school/program.
Grade Grade values are interpreted correctly, especially Kindergarten, Infant/Preschool, and 12+ populations.
EL / RFEP status and dates Status and applicable dates match the district's Aeries records.
Native language Less-common language values are represented correctly in SIRAS.
Race / ethnicity Representative records and population-level counts are reasonably consistent between Aeries and SIRAS.
Contacts Expected contacts are present and interpreted correctly.
Educational Rights Holder If the district uses the Educational Rights Holder flag in Aeries, confirm the expected behavior in SIRAS.

Confirm that the information in SIRAS matches how the district intends the Aeries data to be interpreted.

3. Use optional mapping only when testing exposes a real exception

Start with Aeries defaults. Most districts do not need custom mapping. Do not make the Aeries–SIRAS mapping workbook an upfront implementation requirement.

Examples of exceptions that may require mapping include:

  • a Kindergarten student being interpreted as Infant/Preschool or 12+;
  • a district-specific demographic code whose meaning differs from the normal/default Aeries value; or
  • multiple school/program names for one physical site or CDS code that the district wants distinguished in SIRAS, such as Elementary, Middle, and Preschool programs at the same site.

When an exception is identified, contact [email protected] and use Aeries → SIRAS API Reference: Fields, Defaults & Optional Mapping and the Aeries–SIRAS Integration Configuration & Approval Workbook to document the local rule. Retest the affected data after the mapping is applied.

How you know the Aeries → SIRAS Training test passed:
  • the expected API import run appears in Scheduled Task Logs without an unresolved setup/connection error;
  • representative Training records contain the expected demographic, enrollment, and contact information;
  • any local mapping exception has been corrected and retested; and
  • the district and SIRAS agree that the Training result is ready for Production approval.
What this test changes:
Reviewing logs and student records is view-only. The Aeries → SIRAS import itself can update demographic/contact data in the Training environment. Production is not approved or activated merely because the Training job ran.

Approve and Activate Production

After both applicable data directions have been tested and the district approves the Training results, SIRAS can enable or move the approved configuration to Production.

At that point, implementation-only technical contacts can step back unless they also own ongoing monitoring. The primary SIRAS/SPED/SEDS staff should know where to review:

  • the Aeries Special Ed Data Import completion/report emails; and
  • the SIRAS scheduled-task/API logs available through Tools → SIRAS Admin → Scheduled Task Logs.

Review these weekly or more often when appropriate. Use SIS Integration Troubleshooting & Ongoing Monitoring when an established integration does not behave as expected.

Implementation complete:
SFTP access works, Aeries → SIRAS has been reviewed in Training, SIRAS → Aeries can successfully perform a one-time import and send the expected completion report, Production is approved, and responsible staff know how the integration will be monitored.
scroll to top icon