Microsoft Technology Licensing, LLC

Matthew Carroll

David Noor

Jeffrey Bernhardt

Bekim Demiroski

Adrian Dumitrascu

Robert B Zare

Amir Netz

Cristian Petculescu

Paul Jonathon Sanders

Thomas P Conlon

Andriy Garbuzov

Oleg G Lvovitch

Aleksandar Juric

Kevin Thomas Edward McGuire

Sergio Silveira Clemente Filho

Maria Potapova

Cimarron S Ryan

A system and method for facilitating execution of one or more data integration projects in multiple environments or an environment that undergoes changes. Each project has a set of project parameters, which are bound to environment variables. Each environment has a corresponding environment representation with environment variables and corresponding values. Each project is mapped to an environment representation. Values of environment variables are provided to projects with corresponding parameters. When one or more projects are changed to a different environment with a different corresponding environment representation, the environment variable values of the new environment representation are provided to the projects. When an environment change is reflected in the environment representation, the changed variable values are provided to mapped projects.

Multi-environment configuration of data integration projects

A method includes connecting an integration process to a first set of inputs. The first set of inputs may include one or more inputs. The integration process includes one or more data transformation operations using the inputs. The method further includes receiving metadata about one or more of the inputs in the first set of inputs. The metadata about one or more of the inputs in the first set of inputs is cached. The integration process is then connected to a second set of inputs based on the cached metadata about one or more of the inputs in the first set of inputs.

Flexible order of authoring for data integration solutions

A system and method for extracting data from an input source, transforming the data, and loading the transformed data to an output destination. A schema contract including constraints is used to validate a set of input data column types and translate them into a set of actual types. Mapping data in the schema contract enable mapping input data columns to data columns used by data integration components. The constraints and mapping data provide flexibility in transforming sets of data having different sets of input data column types, while providing a fixed set of types for use during dataflow executions. Flexibility may enable optional columns, sets of one or more columns, varying arrangements of columns, and variations in type definitions of each column.

Schema contracts for data integration

Various technologies and techniques are disclosed for creating and managing a visual representation of OLAP attributes and relationships for a dimension. A visual representation is generated that contains an arrangement of shapes with connections between shapes. One or more sub-elements are contained within at least some of the shapes. Connections between the shapes represent relationships between attributes in an OLAP dimension. The containment of a respective sub-element within a respective shape represents a relationship between an attribute being represented by the respective sub-element and an attribute being represented by the respective shape. Shapes representing OLAP attributes and relationships can be programmatically grouped and ungrouped. When an attribute does not have any outgoing relationships, when an attribute only has one incoming relationship, and when the attribute is not a level in a user-defined hierarchy, a grouping process is performed to put the attribute in an expandable shape belonging to another attribute.

Visual system for visualizing, navigating, and editing attribute lattices within OLAP databases

The subject invention relates to systems and methods that extend the network data access capabilities of mark-up language protocols. In one aspect, a network data modeling system is provided. The system includes a protocol component that employs a computerized mark-up language to facilitate data interactions between network components. An extension component operates with the protocol component to support the data transactions, where the extension component supplies various commands above standard network and database protocols. An object model is provided as a wrapper to the extensions in order to support various online and offline database development applications.

Systems and methods to facilitate utilization of database modeling

A system that facilitates validating an object in a software design tool comprises a component that receives input relating to development of an object. A validating component, prior to compile, automatically determines whether the object is associated with an error upon receipt of the input. An alarm component can generate an alarm upon the validating component determining that the object is associated with an error.

Dynamic object validation

Growing community of inventors

Seattle, WA, United States of America

Matthew Carroll