Resources

How-To Videos from PR3

bpsprecher Education, Hints for DS, Resources

I’ve found a new like-minded friend in Rajeev, who likes to share his knowledge!

Check out his YouTube channel: https://www.youtube.com/user/PR3Systems

Rajeev’s goal is to release a new video each week about Information Server.  “Subscribe” to his channel to be notified of the videos he creates.

This channel contain information about DataStage, Information Analyzer, Change Data Capture (CDC), Information Governance Catalog, etc.:

  • Reading / writing / processing Hadoop files, XML, Excel, etc.
  • Governance
  • Profiling
  • Replication
  • and more!

Real-time Replication with DataStage

bpsprecher Resources

This is an excellent article on how to use DataStage as a target for your IBM InfoSphere Data Replication (IIDR) / Change Data Capture (CDC) processes.

This architecture can be utilized with a package called CDD (Change Data Delivery), which has restrictions.  The target can only be used to feed data to DataStage/QualityStage, MDM Server, and Warehouse.  The number of CDC sources and their operating systems is irrelevant.

Or, the restriction is lifted if IIDR/CDC and DataStage are purchased separately.

Why would someone do this?  With DataStage as a target for your real-time feed of transactions, you can use the power of ETL logic to add complex transformations, multiple targets, lookups, etc.!

http://www.ibm.com/developerworks/data/library/techarticle/dm-1210cdctransactionstage/

IBM Knowledge Center (Documentation, Tutorials, Usage Guides, etc.)

bpsprecher Resources

Welcome to the new home for IBM product documentation. Customize IBM Knowledge Center to design the experience that you want with the technology, products, and versions that you use and by creating your own collection of documents. You can also interact with IBM and with your colleagues by sharing through email, LinkedIn, or Twitter or by adding comments to topics.

http://www-01.ibm.com/support/knowledgecenter/

 

InfoSphere Information Server 11.5.0

http://www..ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.productization.iisinfsv.home.doc/topics/kc_homepage_IS.html

 

InfoSphere Information Server 11.3.0

http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.productization.iisinfsv.home.doc/topics/kc_homepage_IS.html

 

IBM InfoSphere BigInsights – IBM InfoSphere BigInsights delivers a rich set of advanced analytics capabilities that allows enterprises to analyze massive volumes of structured and unstructured data in its native format. The software combines open source Apache Hadoop with IBM innovations including sophisticated text analytics, IBM BigSheets for data exploration, IBM Big SQL for SQL access to data in Hadoop, and a range of performance, security and administrative features. The result is a cost-effective and user-friendly solution for complex, big data analytics

http://www-01.ibm.com/support/knowledgecenter/SSPT3X/SSPT3X_welcome.html

 

InfoSphere Information Server 11.3.0> InfoSphere DataStage and QualityStage

http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.nav.doc/containers/cont_iisinfsrv_ds_and_qs.html – where you can find: Overview of InfoSphere DataStage
IBM InfoSphere DataStage is a data integration solution that collects, transforms, and distributes large volumes of data, with data structures that range from simple to highly complex. and Getting started
Use these tutorials to learn the basic skills that you need to develop parallel jobs that transform data and parallel jobs that cleanse data.

 

InfoSphere Master Data Management 11.4.0> Overview and home

http://www-01.ibm.com/support/knowledgecenter/SSWSR9_11.4.0/com.ibm.mdmhs.homepage.doc/mdm11.4_welcome.html

 

InfoSphere Master Data Management 10.1.0> Overview and home

http://www-01.ibm.com/support/knowledgecenter/SSWSR9_10.1.0/com.ibm.mdmhs.homepage.doc/ic-homepage-mdm-enterprise.html

 

DB2 Query Management Facility

http://www-01.ibm.com/support/knowledgecenter/SS9UMF/welcome.html

Namit Kambra Blog

bpsprecher Resources

An IBMer in India has a very nice InfoServer blog…lots of great information:
http://namitkabra.wordpress.com/

Namit has an excellent blog about Information Integration, Big Data, Cloud, Governance and more.

I like this “full picture” view of InfoServer:
http://namitkabra.wordpress.com/2013/10/07/infosphere-datastage-xviii-full-picture/

Check out the Site Map to see what else he has:
http://namitkabra.wordpress.com/site-map/

Integration and Governance Redbook

bpsprecher Resources

New Redbook! IBM Information Server Integration and Governance for Emerging Data Warehouse Demands:

http://www.redbooks.ibm.com/abstracts/sg248126.html?Open

This Redbook provides an overview of Information Server v9.1 usage on data warehousing projects, and a deep dive into new capabilities around self service (Data Click), Big Data, statistical models, data governance and quality.

Table of contents
Part 1. Overview and concepts
Chapter 1. Overview of IBM InfoSphere Information Server
Chapter 2. Using Information Server to design and implement a Data Warehouse
Part 2. Meeting the increasing demands of workloads, users, and the business
Chapter 3. Data Click: Self-Service Data Integration
Chapter 4. Incorporating new sources: Hadoop and big data
Chapter 5. SPSS: Incorporating Analytical Models into your warehouse environment
Chapter 6. Governance of data warehouse information
Chapter 7. Establishing trust by ensuring quality
Chapter 8. Data standardization and matching

Information Server Grid Redbooks

bpsprecher Resources

Thinking of deploying a Grid? Check out the Redbooks!

Deployment Architecture Redbook. – Dec 2012
http://www.redbooks.ibm.com/redbooks/pdfs/sg248028.pdf

Older “Deploying a Grid Solution with IBM Infosphere Information Server” Redbook – Sept 2008
http://www.redbooks.ibm.com/abstracts/sg247625.html

One additional Redbook:
http://www.redbooks.ibm.com/redpapers/pdfs/redp4596.pdf

Platform LSF is the preferred resource manager over Loadleveller.

Note: the Grid toolkit which supports this style of deployment is not a product, but rather an Advanced Consulting asset delivered as part of a Services engagement.

Solution Guides

bpsprecher Resources

IBM has launched a new form of collateral called a “Solution Guide”. They are basically a 10-15 pager that covers a specific technical area. They are more detailed then a data sheet but not as heavy as a Redbook…even though they are called Redbooks. It sounds as though there may be more coming!

Optimizing Data Integration Solutions by Customizing the IBM InfoSphere Information Server Deployment Architecture
http://www.redbooks.ibm.com/abstracts/tips0964.html?Open

Deploying a Grid Solution with IBM InfoSphere Information Server
http://www.redbooks.ibm.com/abstracts/tips0965.html?Open