Rapid Integration | IBM WebSphere Cast Iron Integration Experts

  • Home
  • Services
  • Training
  • About
  • Contact
  • Home
  • Services
  • Training
  • About
  • Contact

Expert IBM Cast Iron Integration

Tab-Separated to Comma-Separated with a Twist

5/2/2016

0 Comments

 
A recent Cast Iron project involved taking tab-separated files and producing comma-separated files as a result. Seems easy enough? Of course... except three of the five use cases required merging multiple input files before producing the comma-separated output. Since merging files in memory is not a Cast Iron best practice, Rapid Integration used a MySQL database to stage the data. The database query activity allowed us to use SQL to aggregate, sort and dedupe the data so that Cast Iron could do what it does best.
0 Comments

    Archives

    August 2016
    July 2016
    June 2016
    May 2016
    April 2016

    Categories

    All
    Best Practices
    CSV
    Database
    Deployment
    Loggly
    NetSuite
    Salesforce
    SFTP
    Studio
    Web Services
    XSLT

About Us

Contact
About
Rapid Integration
© 2016,2022 Rapid Integration, Inc. All Rights Reserved.​