Enterprise Data Integration Guide

Content
Search Results
Loading, please wait ...

Loading

  • Welcome
  • Introduction
    • Enterprise Data Management Architecture
    • The Star Schema Data Warehouse Design
      • Advantages of a Star Schema
  • Connecting to Data Sources and Data Warehouses
    • Introduction to Data Sources
      • Compression Support for Cloud File Servers
      • Supported Entities and Operations
    • Connection Types
      • Connecting to Amazon
        • Connecting to Amazon DynamoDB
          • Amazon DynamoDB Limitations
        • Connecting to Amazon S3
          • Using Amazon S3 Cloud Encryption
        • Connecting to Amazon SimpleDB
          • Amazon SimpleDB Limitations
      • Connecting to Apache Cassandra
      • Connecting to Azure Cloud
      • Connecting to a Flat File
        • Connecting to a Delimited Flat File
        • Connecting to a Fixed Width Flat File
        • Date Time Formats in a File Connection
      • Connecting to an FTP Server
      • Connecting to Google Cloud Storage
      • Connecting to Hadoop
        • Compression Support for Hadoop
      • Connecting to JDBC
        • Importing a JDBC Driver
        • Manually Adding a JDBC Driver
        • Editing a JDBC Driver
        • Deleting an Imported JDBC Driver
        • Supported Database Data Types
        • Supported Database Data Types for the Location Intelligence Module
      • Connecting to Knox
      • Connecting to Marketo
        • Marketo Limitations
      • Connecting to Microsoft Dynamics 365 Online
      • Connecting to a Model Store
      • Connecting to NetSuite
        • NetSuite Limitations
      • Connecting to NoSQL
      • Connecting to Salesforce
      • Connecting to SAP NetWeaver
        • SAP NetWeaver Limitations
      • Connecting to SharePoint
      • Connecting to Siebel
        • Siebel Limitations
      • Connecting to Splunk
        • Splunk Limitations
      • Connecting to SuccessFactors
        • SuccessFactors Limitations
      • Connecting to SugarCRM
        • SugarCRM Limitations
      • Connecting to a Windows Mapped Drive
    • Deleting a Connection
  • Populating the Data Warehouse
    • Preparing Your Data
    • Populating a Time Dimension Table
    • Populating a Dimension Table
    • Populating a Fact Table
    • Adding a Time Stamp to Records in a Data Warehouse
  • Updating the Data Warehouse
    • Defining a Data Warehouse Update Schedule
    • Updating a Fact Table
    • Using a Global Cache for Queries
      • Deleting a Cache
    • Using a Local Cache for Queries
  • Stages Reference
    • Call Stored Procedure
    • DB Change Data Reader
      • Adding a CDC Resource
      • Editing a CDC Resource
      • Deleting a CDC Resource
      • Selecting Change Data Reader Options
    • DB Loader
      • Oracle Loader
      • DB2 Loader
      • PostgreSQL Loader
      • Teradata Loader
    • Field Parser
    • Field Combiner
    • Field Selector
    • Generate Time Dimension
      • Options
        • Creating a Calendar
      • Output
    • Query Cache
    • Query DB
      • Parameterizing Query DB at Runtime
    • Query NoSQL DB
      • Defining Fields - Query NoSQL DB
      • Configuring Dataflow Options - Query NoSQL DB
    • Read From DB
      • Visual Query Builder
        • Adding Objects to a Query
        • Setting Object Aliases
        • Joining Tables
        • Selecting Output Fields
        • Sorting a Dataset
        • Defining Criteria
        • Grouping Output Fields
        • Defining SQL Query Properties
      • Query Variables
        • Inserting a Query Variable
        • Configuring a Query Variable as a Dataflow Option
        • Configuring a Query Variable for Job Executor
    • Read From File
      • Defining Fields In a Delimited Input File
      • Defining Fields In a Line Sequential or Fixed Width File
      • Sorting Input Records
      • The File Definition Settings File
      • Configuring Dataflow Options
    • Read from Hadoop Sequence File
      • Defining Fields In an Input Sequence File
      • Sorting Input Records
      • Filtering Input Records
    • Read From Hive File
      • Defining Fields for Reading from Hive File
    • Read from HL7 File
      • Flattening HL7 Data
      • Adding a Custom HL7 Message
    • Read from NoSQL DB
      • Defining Fields in a NoSQL Database
      • NoSQL DB Dataflow Options
    • Read from SAP
      • Connecting to SAP
      • Reading Data from a Single SAP Table
      • Reading Data from Multiple SAP Tables
      • Filtering Records in Read from SAP
    • Read from Spreadsheet
    • Read from Variable Format File
      • Defining Fields in Delimited Variable Format Files
      • Defining Fields in a Line Sequential or Fixed Width Variable Format File
      • Flattening Variable Format Data
    • Read From XML
      • Flattening Complex XML Elements
    • SQL Command
      • Specifying SQL Command at Runtime
      • Running A Job from the Command Line
      • Executing SQL Commands Before or After a Dataflow
    • Transposer
    • Unique ID Generator
      • Defining a Unique ID
      • Using Algorithms to Augment a Unique ID
      • Defining a Non-Unique ID
    • Write to Cache
      • Clearing a Global Cache
    • Write to DB
      • Configuring Error Handling in Write to DB
    • Write to File
      • Defining Fields In a Delimited Output File
      • Defining Fields In a Line Sequential or Fixed Width File
      • Sorting Output Records
      • The File Definition Settings File
      • Configuring Dataflow Options
    • Write to Hadoop Sequence File
      • Defining Fields In an Output Sequence File
    • Write to Hive File
      • Defining Fields for Writing to Hive File
    • Write to NoSQL DB
      • Defining Fields in a NoSQL Database
      • NoSQL DB Dataflow Options
    • Write to Spreadsheet
      • Defining fields in an Output file
    • Write to Variable Format File
      • Writing Flat Data to a Variable Format File
      • Tag Names in Variable Format Files
    • Write to XML
      • Using Namespaces in an XML Output File
      • Creating Complex XML from Flat Data
    • Date and Number Patterns
      • Date and Time Patterns
      • Number Patterns
  • Configurations
    • Oracle LogMiner Configurations
  • Optimizing Performance
    • Determining an Optimimum Fetch Size