• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 576
  • Last Modified:

Biztalk overkill

I get a lot of flat files from different formats, which i need to add into database.

For that i was recommended by someone to use Biztalk.
I tried it and made multiple applications for different file formats, I made schema and then added .NET code to add that data in database.  This all worked fine, I had 1 development server which i was using to update database.
Now clients are asking me to give them the application from which they can do the migration themselves.
But Biztalk editions are quite costly and also on further research i found that for such tasks which i am doing, It is over kill to use Biztalk

I want to leave Biztalk now and use some Other application or Library which could convert the flat files to xml and give to my application and then i can use the same code and put data into database.

Please recommend some other library or application which could convert the flat files of different formats using delimeter approach or fixed length approach to xml, which are cheeper or free.
0
armoghan
Asked:
armoghan
  • 2
2 Solutions
 
dportasCommented:
If you just want point to point data conversion then I'd go for one of the data integration (aka ETL) tools rather than BizTalk. Some of them can be expensive too but there are some budget options.

What DBMS are you using? Many DBMSs come with some form of data loader tool. Microsoft SQL Server includes Integration Services which is a very powerful data integration tool that should easily handle your requirements.

Integration Services (included with SQL Server)
http://msdn.microsoft.com/en-us/library/ms141026.aspx

Pervasive Data Integrator (a decent budget ETL package)
http://ww2.pervasive.com/Integration/Products/Pages/PervasiveDataIntegrator.aspx
0
 
abelCommented:
> Please recommend some other library or application which could convert the flat files of different formats
> using delimeter approach or fixed length approach to xml, which are cheeper or free.

Turning flat files into XML can be done by using XSLT 2.0 (not to be confused with 1.0!).

If you need to do this on a regular basis, I also have a full working system for you that can do this task from a web interface or fully automatically. It's a web application. Since it is a left over from a company take-over, I can only use parts of it and it's copyrighted (though source is included). You can contact me by phone or by email if you are interested in a professional transformation server for not too high costs (and: easy to setup, configure, maintain and use).
0
 
abelCommented:
Proposal, based on the content of the comments:

answer: dportas (#24174548): 350 pts
assist: abel (#24174600): 150 pts
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now