ICON2010Mappingx - Informer Client Portal - Entrinsik

sunfloweremryologistData Management

Oct 31, 2013 (3 years and 11 months ago)

209 views

Mappings





2010 Copyright Entrinsik, Inc.

Setup and maintenance of
Datasources


PRESENTER:
Andrew Morovati
|

Informer Product
Manager
|
Entrinsik



Outline



Describe the Datasource object model:
Datasources
, Mappings, Properties,
Links
and Mapping Suites


Set up
datasources


Explore Property formats


Link mappings


Use the column usage and condition usage lists


Set
up a mapping
suite


Describe the effects of deleting a datasource object


© 2010 Entrinsik, Inc.



Datasources


A
Datasource is a connection to a database.

Informer
currently supports many database types
.

© 2010 Entrinsik, Inc.



Supported Databases


SQL Databases


Oracle


Microsoft SQL Server


IBM DB2


Apache Derby


MySQL


PostgreSQL


Informix


Sybase SQL


© 2010 Entrinsik, Inc.



Supported Databases



Multi
-
Value Databases


Unidata


Universe


Other databases


Microsoft Access 2003/2007


BTRIEVE


Cache 2007.1



© 2010 Entrinsik, Inc.



Mappings



Represent SQL tables,
SQL
Views,
or U2
Files


Consist
of properties and
links


Can be secured for reporting with permissions


Do
not need to contain all the columns or fields in the entity


May have multiple mappings pointing at the same table


© 2010 Entrinsik, Inc.



Properties


Define which columns are exposed.


Are typed to support formatting


Text


Numeric


Date


Time


Boolean


May be secured
for use
in select statements and/or report columns


May be associated with code files for data translation


© 2010 Entrinsik, Inc.



Links



Link two mappings together, like SQL joins


All
links
may be used to display linked properties from other mappings.


Local
links involve two
mappings within the same database, and may be used for
selection criteria. Exception: Linked U2 I
-
descriptors.


Remote links involve two
mappings in different
datasources
. No fields from remote
joins may be used in selection criteria.


All links behave like SQL left joins, meaning linked columns may be blank if the
linked field’s key field has no value, yet rows will still display.


© 2010 Entrinsik, Inc.



Mapping Suites


A
Mapping Suite

is a group of mappings where each mapping contains a list of
multiple tables.


Each tables listed with a mapping must contain the exact same
columns, as defined on the mapping


Reports will use the identified default mapping or may be configured
to prompt the user for what group of tables to use


Tables are identified by a name, and multiple mappings must each
have a table listed under each name


Mapping suites may span
datasources


© 2010 Entrinsik, Inc.



Create a Datasource



Identify
your connection settings


Server name


Datasource type


Port


Any additional connection properties


Add the datasource in Informer


If non
-
admin principal permissions aren’t set in “Root Permissions”,
this datasource is not visible to anyone but administrators (those with
Datasource full control rights)


© 2010 Entrinsik, Inc.



Add Mappings



Choose
a table, file or view from the “Add” button.


Name the mapping something meaningful.


Add as many as desired to the grid.


Click “Save”.


© 2010 Entrinsik, Inc.



Add Properties to a Mapping



For SQL tables, “Add all” is a good method, because all columns in
the table will be unique data elements


For U2 Files, be more selective, since you most often need only one
property for each data element, and most U2 databases contain
multiple fields referring to the same data attribute


Attribute
-
based:


Click ‘Add’


Check Search By Attribute


Double click each field by attribute


Report
-
based


only add fields as requested for reports

© 2010 Entrinsik, Inc.



Editing Properties in the Grid

You can change several aspects of properties directly in the grid


Name


Data type (U2 only)


Multi
-
valued (U2 only)


© 2010 Entrinsik, Inc.



Editing Properties in Detail


Data type is usually imported correctly. Changing the data type affects
U2 queries but not SQL queries


Text fields may specify a conversion code


Code files will be covered later


Auto suggest


may use code file


select
distinct values from the database (use sparingly)


Default formats only apply to columns added after the change



© 2010 Entrinsik, Inc.



Editing Properties in Detail



Description shows up in runtime criteria as a help button.


Multivalued and
Subvalued

check boxes must be accurate for data to
be retrieved correctly.


Character length will apply to newly added columns only.


© 2010 Entrinsik, Inc.



Creating Links


U2 Links


Intra
-
datasource: All are foreign key relationships, where
mapping contains
key to linked mapping


Remote: Link to another source in either direction


You can do reverse foreign key relations with a remote link, but it may make
queries run a lot slower



© 2010 Entrinsik, Inc.



Creating SQL Links



Foreign Key


mapping contains primary key to linked mapping


Reverse Foreign Key


linked mapping contains a primary key to the
mapping


Key from Third Table


a “middle” table contains key to mapping and
key to linked mapping


Non
-
primary key


link between a property on mapping and property
on linked mapping

© 2010 Entrinsik, Inc.



Remote Links



Link
datasources
!


May not be used in selection criteria


Data is collated within Informer process.

© 2010 Entrinsik, Inc.



Mapping Suites



Use mapping suites when you have 2 or more tables with the exact
same structure, and you want to re
-
use reports among them.


Reports will use the default mapping suite, or can be configured to
prompt the user


If mappings have links, if the linked mapping is part of the mapping
suite, then the links will switch in sync when the particular table set is
switched.


Once a mapping suite is created, table sets may be created or
removed at any time.

© 2010 Entrinsik, Inc.



Deleting items


Deleting an association doesn’t affect the structure of reports, but
they may have columns that won’t work


Deleting a property could break a condition, but will remove columns
from reports. There are views of where the property is used to help
you determine what the effects will be.


Deleting a mapping removes all reports directly off the mapping as
well as any report referencing the mapping


Deleting a datasource will have the same effect as deleting all the
mappings, as well as delete any code files off it.


© 2010 Entrinsik, Inc.



Resources



HTML:
http://www.w3schools.com/html/html_examples.asp


JavaScript:
http://www.w3schools.com/js/js_examples.asp


CSS (styles):
http://www.w3schools.com/css/css_examples.asp


Reports from today:
http://trial.entrinsik.com:8080


YouTube examples:
http://www.youtube.com/entrinsikinc


Portal examples:
http://delivery.entrinsik.com/portal/index.php?board=6.0


© 2010 Entrinsik, Inc.



Thank you! Any questions?

© 2010 Entrinsik, Inc.