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

Does Sybase have its own ETL tool?

Does Sybase have its own ETL tool?  I heard there is something called Sybase Data Loader, but I don't have a chance to really look at tool.  Anyone can help to explain to me a little bit?  Thanks.
0
thomaszhwang
Asked:
thomaszhwang
  • 3
  • 2
4 Solutions
 
Joe WoodhousePrincipal ConsultantCommented:
Sybase's industrial-strength ETL tool is Informatica. That's a true ETL tool in that it allows you very complicated logic for how to extract from source data, and transform it beyond recognition. It is overkill for most scenarios - unless you're talking about a brand new greenfields data warehouse where data has never before existing in this form, in which case it probably saves time. Expect a fairly steep learning curve, but this tool can do just about anything.

At the opposite end of the scale is Sybase's "bcp". This is a free tool bundled with Sybase ASE and all it does is move data from a file to a table, or from a table (or view) to a file, one object at a time. It has no transformation ability for loading data into ASE, but note that being able to bcp out of a view means for data extracts you now have a fair bit of transformation possibilities.

The brand new Data Loader was introduced as part of Sybase ASE's IMDB (in memory database) premium option, and is intended for loading up a transient in-memory database from a (fairly) static template database. That said you can also use it for other traditional data loading tasks. Note I say loading - it's basically like bcp, in that it does extracts and loads but no transformation.

There are plenty of third party tools out there, most of them cheaper than Informatica and more flexible than bcp. That said, it really isn't that difficult to do basic transformation either at the operating system level, or if there's any kind of filtering or aggregation going on, stage the raw data in your database and do the transformation there.

Tell us more about your problem and what you're trying to solve?
0
 
drittenhCommented:
Just to add to Joe's comments, Sybase has its own ETL tool (called "Sybase ETL") which is a separate licensable option to the IQ product.  It can do many of the things Informatica does, including create IQ binary loader files, whereas the loader files produced by Informatica are not optimised for use with IQ.  Worth a look if your budget does not extend to "the full blown ETL engine" provided by Informatica.  

HTH,

David
0
 
Joe WoodhousePrincipal ConsultantCommented:
Good point, forgot about that one!!
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
thomaszhwangAuthor Commented:
Isn't Informatica a separate company?
0
 
Joe WoodhousePrincipal ConsultantCommented:
I guess so... and Sybase resells it. drittenh has reminded us about Sybase's own Sybase ETL tool.
0
 
thomaszhwangAuthor Commented:
Thanks.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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