Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    4

    Unanswered: Data Integration Tools Recommendation

    Hi all

    In our company we do a lot of data imports from various files/data stores.

    I was wondering what are the good Data Integration software out there which can provide "industrial-strength" to this process. I heard one of them is Informatica (www.informatica.com) but that seems more for Data Warehousing.

    Our DB is SQL Server. Maybe we should change that too?

    Comments/Suggestions, anyone?

    Much Appreciated,
    Manik

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Why can't you use DTS from SQL server?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jun 2003
    Posts
    4
    Hi Satya

    We use DTS right now. However, the problem is that DTS is not giving us very good performance.

    What we really need is a software that can help us model the data import process and then run the import and provide logging etc.

    DTS works ok for now but we have cases where we have to update several thousand records against a > 1000 row Excel file and we have to do this very often (and also on demand). This is very slow.

    Also, the various imports are getting bigger and more cumbersome to manage, hence the need for an integrated tool that can create, manage and execute these imports in a systematic manner.

    Regards
    Manik

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Not aware of such tools but you can search under SQL Performance website for any recommendations and information.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •