SQL Server 2012 & ETL ...
3 posters
Page 1 of 1
SQL Server 2012 & ETL ...
All,
Has anyone as yet explored the ETL/BI features in SQL Server 2012? If so, has anyone used the Data Cleansing tool that comes with 2012 or any other EDW related features that there might be?
I maintain a SQL Server 2008 EDW, but would be interested in upgrading it to 2012 if there are measurable benefits.
I have only just installed 2012 and now starting to evaluate it, so it's still early days for me.
Thanks in advance.
Cheers,
Ben.
Has anyone as yet explored the ETL/BI features in SQL Server 2012? If so, has anyone used the Data Cleansing tool that comes with 2012 or any other EDW related features that there might be?
I maintain a SQL Server 2008 EDW, but would be interested in upgrading it to 2012 if there are measurable benefits.
I have only just installed 2012 and now starting to evaluate it, so it's still early days for me.
Thanks in advance.
Cheers,
Ben.
bhorin- Posts : 1
Join date : 2012-06-14
Re: SQL Server 2012 & ETL ...
I've looked and played with data quality services and it seems quite good and the price is right. Master Data Management is on the radar to look at and adds additional value. I would think these two features alone would make the upgrade to 2012 worth while for most microsoft shops. Was hoping the metadata offering (barcelona) might tempt us further but after scratching the surface it does not appear to be a viable option.
robber- Posts : 41
Join date : 2009-02-28
Location : Canada
Re: SQL Server 2012 & ETL ...
My friend James Beresford has a log where he explores DQS in SQL 2012:
www.bimonkey.com
www.bimonkey.com
Similar topics
» Any Benefit to Defining Foreign Keys in SQL Server without enforcing foreign key constraint in SQL Server
» SQL_Server 2012 - Columnar Indexes or Netezza
» ETL Server Sizing
» Implementing secondary indexes on fact tables. Is it a good idea?
» ETL from SAP ECC to SQL Server DW
» SQL_Server 2012 - Columnar Indexes or Netezza
» ETL Server Sizing
» Implementing secondary indexes on fact tables. Is it a good idea?
» ETL from SAP ECC to SQL Server DW
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum