Transcript Transform - Information Builders

Data Management Console
Synonym Editor
Clif Kranish
Director, Product Management
Data Management Console
Agenda
 Managing Metadata and Procedures
 The Synonym Editor and Cluster Joins
 Editing and using Defined Functions
 DataMigrator
Managing Metadata and Procedures
Data Management Console
Windows application installed with
WebFOCUS Server
iWay Server or Client
4
Data Management Console - Browser
Servers and Application Directories
Browser
Filters: Procedures - Synonyms
Browser
Clear Filter
Browser
Customize
Browser
Folder Descriptions
Data Management Console
Explorer View
Explorer View
Customize columns displayed
Explorer View
Customize – Datetime modified – Sort
. 12
Browser
Synonym Operations – Data Profiling
13
Data Profiling
Statistics
14
Data Profiling
Key Analysis – New in Release 7.7.02
15
Data Profiling
Key Analysis – New in 7.7.02
16
Browser
Multi-Select – Copy, Cut (new) and Paste
Data Management Console
New “Aerial View” gives overview
Access Control
Browser view depends on role
Basic User
Application Administrator
Server Administrator
Synonym Editor and Cluster Joins
How do you simplify
reporting from mulitple tables?
Create Synonym
Select Adapter and Connection
Create Synonym
Select Object Type and Database
Create Synonym
Select Table(s)
Open Synonym
Synonym Editor Create Cluster Join
Add Reference (new) or Copy of Existing Synonym
Insert by Reference
Show Synonyms with Matching Keys
Cluster Join
Dimensions joined to Facts
Cluster Join
Sample Data
Cluster Join
Modeling View
Define Functions
What if you need to do the same defines
over and over again?
Define Function
 Same calculations needed for multiple fields
 Now create reusable function in FOCUS language
 Use in synonyms and reporting
 Like built-in FOCUS or user functions
 Take one or more parameters
 Return a single result
 Example:
 Input is last name and first name fields
 Output is one field as Last, First
Defined Functions
Stored on server as new procedure type
Defined Functions
Create
New Function
Prototype
New Function
Change the Name of the Function… and the result
Paramaters
Change the Parameter Name and Usage
Parameters
Change the Parameter Name and Usage
Parameters
Add Description, Check Show Field List
Parameters
Add Second Parameter
Parameters
Second Parameter
Defines
Add Define
Defines
Add Define Expression
Defines
Add Define for First Name
Defines
Define for First Name
Defines
Defines for First and Last Name added
Defines
Assign Result
Define Function
Test
Define Function
Save
Define Functions
Use in Synonym Editor
Define Functions
Use in Synonym Editor
Define Functions
Use in Synonym Editor
Define Functions
Use
Define Functions
Test with Sample Data
Define Funtction
Sample Data
DataMigrator
Extract – Transform - Load
DataMigrator Overview
DataMigrator is an ETL tool
 Extract data from
 Any data source
 Generate SQL SELECT statement
 Uses same data adapters as Web FOCUS
 Transform data to achieve consistency
 Virtual column in file description
 Source transformation in the flow
 SQL calculation
 Target transformation
 Load into data targets
 Relational databases
 Flat files, delimited files, XML
DataMigrator
Primary Uses
 Creating data marts and data warehouses
 Staging for WebFOCUS
 Faster access with all data on one platform
 Simpler navigation
 Application loading
 Specific formats required for new applications
 Extend life of legacy applications
 Database conversions or migrations
 One time conversion
 Ongoing parallel operation
Data Flow
Join multiple sources and load
Process Flow
Parallel Group with multiple data flows
Data Management Console
Synonym Editor
Thank you!