Load 837 X12 files into an EDI Database with our DB schema and database mapping translator. T-Connect database is an enterprise ready solution. We've come across many companies that try to build out their own database solution and quickly realize that it comes at significant costs. Create transformations using XML and CSV files directly into the DB.
Build vs. Buy EDI Databases
We've spent 1,000's of hours perfecting the right level of normalization and flattened structure to ensure that it's performance, ease-of-use, and time-to-market meets the business expectations. Our solution can be installed and processing EDI 834 and EDI 837s in under 1 hour. Companies that try to build their own typically run into the same pitfalls and end up scrapping the project. It's simple economics to purchase a proven database solution that can process millions of records, simplify data access, and leverage pre-built patterns and server maintenance jobs. Storing EDI is a very complex solution and most systems out there does not store the complete EDI data elements. Caliber Health's T-Connect solution provides all the necessary tables, maintenance jobs, data access views and stored procedures. We also provide the parsing engine that loads data to and from the tables.
More than a Schema and Translator
T-Connect provides various ways to access the database EDI information. Some of our clients like to ETL the EDI data from T-Connect to their applications and systems. Others utilize our APIs and build real-time solutions that access the data. Users can query straight from the tables using our pre-built stored procedures or integrate using our API's that come with our SDK solution. Our parsing solution writes to the DB out-of-the-box. Its a complete solution that polls for EDI files in a file directory, parses, validates, and stores the ENTIRE data elements into the tables. Outbounding the EDI files are just as easy. We provide stored procedures that bring back the data into the EDI format or use our SDK API solution to export EDI from the data storage. The bottom line is that our solution provides many ways of inputting and outputting information using our solution.
Database Schema Design
Another thing to consider is using naming conventions that match the TR3 Spec Schemas. Data storage for healthcare has complicated transaction sets, like the EDI 837. It's important for users familiar with EDI to be able to understand the structure of each transaction set.
T-Connect data storage is included in two of our products: EDI Gateway and our SDK Plus Database solutions. Check out website for more information on how we use X12 data storage for healthcare!