MapForce 2008
What's new in MapForce Version 2008 R2
What's new in MapForce Version 2008
What's new in MapForce Version 2007 R3
MapForce overview
Terminology
MapForce components
Functions and libraries
Function context menu
Projects
Mapping between components
Missing items
Validating mappings and mapping output
XSLT, Output tab - generating XSLT or program code
Generating XQuery 1.0 code
Loops, groups and hierarchies
MapForce tutorial
Setting up the mapping environment
Mapping schema items
Using functions to map data
Filtering data
Generating XSLT 1.0 and 2.0 code
Multiple target schemas / documents
Viewing and generating multiple target schema output
Mapping multiple source items, to single target items
Creating the mappings
Duplicating input items
Database to schema mapping
Mapping database data
Methods of mapping data (Standard / Mixed / Copy All)
Source driven / mixed content mapping
Default settings: mapping mixed content
Mixed content example
Source-driven / mixed content vs. standard mapping
Copy-all connections
Connector properties
Global Resources
Global Resources - Files
Defining / Adding global resources
Assigning a global resource
Using / activating a global resource
Global Resources - Folders
Global Resources - Application workflow
Start application workflow
Global Resources - Databases
Global Resources - Properties
How To... Filter, Transform, Aggregate
Filter - retrieving dynamic data, lookup table
Filter components - Tips
Value-Map - transforming input data
Value-Map component properties
Aggregate functions: min, max, sum
Mapping multiple tables to one XML file
Mappings and root element of target documents
Boolean values and XSLT 1.0
Boolean comparison of input nodes
Priority Context
Command line parameters
Input values, overrides and command line parameters
Filtering database data by date
Node testing, exists / not-exist
Mapping missing nodes - using Not-exists
Using DTDs as "schema" components
Type conversion checking
MapForce Exceptions
Preview mappings - MapForce Engine
Databases and MapForce
JDBC driver setup
Development environments for code generation
Mapping XML data to databases
Setup of XML to database mapping
Inserting databases - table preview customization
Components and table relationships
Database action: Insert
Database action: Update
Update if... combinations - with delete child data
Database action: Delete
Database Key settings
Database Table Actions and transaction processing
Generating output values
Database feature matrix
Database info - MS Access
Database info - MS SQL Server
Database info - Oracle
Database info - MySQL
Database info - Sybase
Database info - IBM DB2
Database relationships and how to preserve or discard them
Local Relations - creating database relationships
Mapping large databases with MapForce
Complete database import
Partial database import
Database Filters and queries
Database, Null processing functions
SQL WHERE Component / condition
SQL WHERE operators
Mapping XML data to / from databases generically
IBM DB2 - Mapping XML data to / from databases
Querying and mapping XML data in IBM DB2
Mapping XML data - IBM DB2 as target
Mapping data - database to database
Querying databases directly - Database Query tab
Selecting / connecting to a database
Selecting a database Global Resource
Querying data
Database Query - SQL window
Generating SQL statements
Executing SQL statements
Saving and opening SQL scripts
SQL Editor features
Autocompletion
Commenting out text
Using bookmarks
Inserting regions
Database Query - Browser window
Filtering and finding database objects
Context options in Browser view
Database Query - Results & Messages tab
Database Query - Settings
SQL Editor options
Text font
Autocompletion
Result view
Grid font
Using the Connection Wizard
Managing XML Schemas
SQL SELECT Statements as virtual tables
Creating SELECT statements
SELECT statement example
Mapping CSV and Text files
Mapping CSV files to XML
XML to CSV, iterating through items
Creating hierarchies from CSV and fixed length text files
CSV file options
Mapping Fixed Length Text files (to a database)
Fixed Length Text file options
Mapping Database to CSV/Text files
Defining User-defined functions
Inline vs. Standard user-defined functions
Standard user-defined function
Complex user-defined function - XML node as input
Complex input components - defining
Complex user-defined function - XML node as output
Complex output components - defining
User-defined function - example
Adding custom XSLT and XQuery functions
Adding custom XSLT 1.0 functions
Adding custom XSLT 2.0 functions
Adding custom XQuery functions
Aggregate functions - summing nodes in XSLT1 and 2
Adding custom Java, C# and C++ function libraries
Configuring the mff file
Defining the component user interface
Function implementation details
Writing your libraries
Create a Java library
Create a C# library
Create a C++ library
MapForce plug-in for MS Visual Studio .NET
Opening MapForce files in MS VS .NET
Differences between .NET and standalone versions
MapForce plug-in for Eclipse
Installing MapForce plugin
Starting Eclipse and using MapForce plugin
MapForce / Editor, View and Perspectives
Importing MapForce examples folder into Navigator
Creating new MapForce files (mapping and project file)
MapForce code generation
Build mapping code manually
Using MapForce Eclipse projects for automatic build
Adding MapForce nature to existing Eclipse Project
Extending MapForce plug-in
MapForce Reference
File
Edit
Insert
Project
Component
Connection
Function
Output
View
Tools
Help Menu
Table of Contents, Index, Search
Activation, Order Form, Registration, Updates
Other Commands
Oracle client installation
Code Generator
Introduction to code generator
What's new ...
Generating program code
Generating Java code
Generating Java code using Sun ONE Studio
Generating C# code
Generating C++ code
Code generation mapping example
Integrating MapForce code in your application
MapForce code in Java applications
MapForce code in C# applications
MapForce code in C++ applications
Data Stream support
Using the generated code library
Example schema
Using the generated Java library
Using the generated C++ library
Using the generated C# library
Using generated code compatible to old versions
Creating XML files (XMLSpy 2006)
Creating XML files (XMLSpy 2005)
Opening and parsing existing XML files (XMLSpy 2006)
Opening and parsing existing XML files (XMLSpy 2005)
Code generation tips
Code generator options
The way to SPL (Spy Programming Language)
Basic SPL structure
Declarations
Variables
Predefined variables
Creating output files
Operators
Conditions
foreach
Subroutines
Subroutine declaration
Subroutine invocation
Subroutine example
Built in Types
Library
Namespace
Type
Member
NativeBinding
Facets
Old object model (up to v2007)
Namespace
Class
Member
Facet
Enumeration
Pattern
The MapForce API
Overview
Object model
Example: Code-Generation
Example: Project Support
Error handling
Object Reference
Application
Events
OnDocumentOpened
OnProjectOpened
ActiveDocument
ActiveProject
Application
Documents
HighlightSerializedMarker
Name
NewDocument
NewProject
OpenDocument
OpenProject
OpenURL
Options
Parent
Project
Quit
Visible
WindowHandle
MapForceView
Active
Application
HighlightMyConnections
HighlightMyConnectionsRecursivey
InsertXMLFile
InsertXMLSchema
InsertXMLSchemaWithSample
Parent
ShowItemTypes
ShowLibraryInFunctionHeader
Document
Events
OnDocumentClosed
OnModifiedFlagChanged
Activate
Application
Close
FullName
GenerateCHashCode
GenerateCppCode
GenerateCodeEx
GenerateJavaCode
GenerateOutput
GenerateXQuery
GenerateXSLT
GenerateXSLT2
HighlightSerializedMarker
JavaSettings_BasePackageName
MapForceView
Name
OutputSettings_ApplicationName
OutputSettings_Encoding
Parent
Path
Save
SaveAs
Saved
Documents
Application
Parent
Count
Item
NewDocument
OpenDocument
ActiveDocument
ErrorMarkers
Application
Count
Item
Parent
ErrorMarker
Application
DocumentFileName
ErrorLevel
Highlight
Serialization
Text
Parent
Options
Application
CodeDefaultOutputDirectory
CompatibilityMode
CppSettings_DOMType
CppSettings_GenerateVC6ProjectFile