Key Takeaways
- Document ingestion from SharePoint, S3, Box, Dropbox, and major VDRs
- Policy admin integration with Guidewire, Duck Creek, Sapiens, and others
- Data warehouse export to Snowflake, Databricks, and cloud data lakes
- API-first architecture supports custom integrations
- Real-time sync or batch processing depending on use case
- Webhook notifications trigger downstream workflows on extraction completion
- Field mapping ensures data lands in the right system columns
What Ultrassure Does
- Ingests documents from 15+ repository types automatically
- Exports structured data to policy admin systems via certified connectors
- Syncs extracted data to data warehouses in real-time or batch
- Provides REST APIs with comprehensive documentation and SDKs
- Supports SFTP, email, and web portal ingestion for flexibility
Frequently Asked Questions
How does SharePoint integration work?
Ultrassure connects via Microsoft Graph API. You configure watched folders, and new documents are automatically ingested. Extracted data can write back to SharePoint metadata columns or export to other systems.
What about S3 and cloud storage?
S3 integration uses IAM roles or access keys. Configure bucket paths for ingestion, and Ultrassure polls for new files or responds to S3 event notifications. Extracted data exports to S3, other buckets, or downstream systems.
Which policy admin systems are supported?
Certified integrations exist for Guidewire (PolicyCenter, ClaimCenter), Duck Creek, Sapiens, and Majesco. Custom integrations are available for other systems via API or file-based exchange.
How do I get data into my data warehouse?
Ultrassure exports to Snowflake, Databricks, BigQuery, and Redshift via direct connectors. Data lands in your schema with configurable field mapping. Real-time streaming or nightly batch options are available.
What data formats are supported for export?
Export formats include JSON, CSV, XML, and Parquet. API responses return JSON by default. File exports can be configured for specific downstream system requirements.
Can I trigger workflows when extraction completes?
Yes. Webhooks notify external systems on extraction completion, validation failure, or exception flagging. Use webhooks to trigger RPA, update dashboards, or route documents to review queues.
How is field mapping configured?
A mapping interface lets you connect Ultrassure extracted fields to your target system columns. Transformations (date format, currency conversion, concatenation) are configurable without code.
What about virtual data rooms (VDRs)?
Ultrassure integrates with major VDRs including Intralinks, Datasite, and Firmex. Documents in M&A, portfolio transfer, or renewal data rooms are ingested and extracted for due diligence analysis.
Is there an API for custom integrations?
Yes. A comprehensive REST API covers document upload, extraction status, data retrieval, and configuration. SDKs are available for Python, JavaScript, and .NET. API documentation includes examples and Postman collections.
How do I handle legacy systems without APIs?
For legacy systems, Ultrassure supports file-based integration (SFTP, network shares) and can generate formatted outputs for screen scraping or RPA ingestion. We work with your team to design appropriate bridges.