Tag: Data Integration

Technology - Why Business Intelligence (BI) needs a Semantic Data Model

Technology – Why Business Intelligence (BI) needs a Semantic Data Model

A semantic data model is a method of organizing and representing corporate data that reflects the meaning and relationships among data items. This method of organizing data helps end users access data autonomously using familiar business terms such as revenue, product, or customer via the BI (business intelligence) and other analytics tools. The use of a semantic model offers a consolidated, unified view of data across the business allowing end-users to obtain valuable insights quickly from large, complex, and diverse data sets. What is the purpose of semantic data modeling in BI and data virtualization? A semantic data model sits

Continue reading

Technology – Denodo Virtual Dataport (VDP) Naming Convention Guidance

Denodo provides some general Virtual Dataport naming convention recommendations and guidance.  First, there is the general guidance for basic Virtual Dataport object types, and secondly, more detailed naming guidance recommends.       Denodo Basic Virtual Dataport (VDP) Object Prefix Recommendations Associations Prefix: a_{name} Base Views Prefix: bv_{SystemName}_{TableName} Data Sources Prefix: ds_{name} Integration View Prefix: iv_{name} JMS Listeners Prefix: jms_{name} Interfaces Prefix: i_{name} Web Service Prefix: ws_{name} Virtual Dataport (VDP) High-Level Project Structure Different layers are identified when creating logical folders hierarchies within each Data Virtualization project.  The recommended high-Level project folders are: Connectivity Connectivity, where related physical systems, data sources, and base views

Continue reading

How to get a list of installed InfoSphere Information (IIS) Server products

Which File contains the list of Installed IIS products? The list of installed products can be obtained from the Version.xml file. Where is the Version.xml file located? The exact location of the Version.xml document depends on the operating system in use and where IIS was installed to, which is normally the default location of: For Linux, Unix, or AIX /opt/IBM/InformationServer For Windows C:IBMInformationServer

Continue reading

Infosphere Information Server (IIS) – Where you can view DataStage and QualityStage Logs?

During the course of the week, the discussion happened regarding the different places where a person might read the DataStage and QualityStage logs in InfoSphere. I hadn’t really thought about it, but here are a few places that come to mind: IBM InfoSphere DataStage and QualityStage Operations Console IBM InfoSphere DataStage and QualityStage Director client IBM InfoSphere DataStage and QualityStage Designer client by pressing Ctrl+L Related Reference IBM Knowledge Center> InfoSphere Information Server 11.7.0 > InfoSphere DataStage and QualityStage > Monitoring jobs https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.monitor.doc/topics/cont_dsqsmonitor.html IBM Knowledge Center > InfoSphere Information Server 11.7.0 > Installing > Troubleshooting software installation > Log files https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.7.0/com.ibm.swg.im.iis.productization.iisinfsv.install.doc/topics/ts_cont_logfiles.html

Continue reading

Parallel jobs on Windows fail with APT_IOPort::readBlkVirt;error

This a known error for windows systems and applies to DataStage and DataQuality jobs using the any or all the three join type stages (Join, Merge, and Lookup). Error Message <<Link name>>,0: APT_IOPort::readBlkVirt: read for block header, partition 0, [fd 4], returned -1 with errno 10,054 (Unknown error) Message ID IIS-DSEE-TFIO-00223 Applies To Windows systems only Parallel Engine Jobs the three join type stages (Join, Merge, and Lookup). It does not apply to Server Engine jobs. Infosphere Information Server (IIS), Datastage and DataQuality 9.1 and higher The Fix Add the APT_NO_IOCOMM_OPTIMIZATION in project administrator and set to blank or 0.

Continue reading

What are the Core Capability of Infosphere Information Server?

Three Core Capabilities of Information Server InfoSphere Information Server (IIS) has three core capabilities: Information Governance Data Integration Data Quality What the Core Capabilities Provide The three-core capability translate in to the high-level business processes: Information Governance – Understand and collaborate Provides a centrally managed repository and approach, which provides: Information blueprints Relationship discovery across data sources Information technology (IT)-to-business mapping Data Integration – Transform and deliver A data integration capability, which provides: Transformation Massive scalability Power for any complexity Total traceability Delivery Data capture at any time Delivery anywhere Big data readiness Data Quality – Cleanse and monitor To

Continue reading