Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC for MongoDB User's Guide Release 8.0.1

Mapping native objects in a schema

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for ODBC for MongoDB Driver
    • What's new in this release?
    • Driver requirements
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Support for multiple environments
      • Support for Windows environments
        • 32-bit driver
        • 64-bit driver
        • Setup of the driver
        • Driver file names for Windows
      • Support for UNIX and Linux environments
        • 32-bit driver requirements
        • 64-bit driver requirements
        • AIX
        • HP-UX 11 aCC
        • Linux
        • Oracle Solaris
        • Setup of the environment and the drivers
        • Driver names for UNIX/Linux
    • Data types
      • Default mapping of columns with inconsistent native data types
      • Retrieving data type information
    • Mapping objects to tables
      • Normalizing native data
      • Mapping nested complex types
      • Flattening native data
    • Contacting Technical Support
  • Getting started
    • Configuring and connecting on Windows
      • Setting the library path environment variable (Windows)
      • Configuring a data source
      • Testing the connection
    • Configuring and connecting on UNIX and Linux
      • Environment configuration
      • Test loading the driver
      • Setting the Library Path Environment Variable (UNIX and Linux)
      • Configuring a data source in the system information file
      • Testing the connection
  • Tutorials
    • Accessing Data in Tableau (Windows only)
    • Accessing data in Microsoft Excel (Windows only)
    • Accessing data in Microsoft Excel from the Query Wizard (Windows only)
  • Using the driver
    • Configuring and connecting to data sources
      • Configuring the product on UNIX/Linux
        • Environment variables
          • Library search path
          • ODBCINI
          • ODBCINST
          • DD_INSTALLDIR
        • The test loading tool
        • Data source configuration on UNIX/Linux
          • Configuration through the system information (odbc.ini) file
            • Sample default odbc.ini file
        • The example application
        • DSN-less connections
          • Sample odbcinst.ini file
        • File data sources
        • UTF-16 applications on UNIX and Linux
      • Data source configuration through a GUI
        • SQL Engine tab
        • Advanced tab
        • Security tab
      • Using a connection string
      • Using a logon dialog box
    • Creating and customizing schemas using the DataDirect Schema Tool
      • Starting the Schema Tool
        • Starting the Schema Tool on UNIX/Linux
        • Starting the Schema Tool on Windows
      • Creating a schema with the Table Wizard
        • Generating a normalized view
        • Generating a flattened view
        • Starting with custom view
      • Customizing your schema
        • Viewing information and statistics
          • About column information and statistics
        • Mapping native objects in a schema
          • Mapping native objects
          • Mapping newly detected objects
        • Extracting a new table
        • Adding columns
        • Removing objects from a schema
        • Removing columns
        • Defining columns
        • Designating a primary key
        • Naming conflicts
      • Restarting the wizard
    • Performance considerations
    • Configuring the SQL engine server
      • Configuring server mode
      • Starting the SQL engine server
      • Stopping the SQL engine server
      • Configuring Java logging for the SQL engine server
    • Using security
      • Data encryption across the network
      • TLS/SSL encryption
        • Certificates
        • TLS/SSL server authentication
        • TLS/SSL client authentication
      • Using security with the Schema Tool
        • Configuring security for the Schema Tool on Windows
        • Configuring security for the Schema Tool on UNIX/Linux
      • Summary of security-related options
    • Using identifiers
    • Using IP addresses
    • SQL support
    • Parameter metadata support
      • Insert and Update statements
      • Select statements
    • Binding parameter markers
    • Isolation and lock levels supported
    • MongoDB sharding support
    • Number of connections and statements supported
    • Unicode support
  • Connection option descriptions
    • Application Using Threads
    • Config options
      • columnDiscoverySampleSize (config option)
      • DefaultVarcharSize (config option)
      • KeywordConflictSuffix (config option)
      • LeadingUnderscoreReplacement (config option)
      • MaxVarcharSize (config option)
      • MinVarcharSize (config option)
      • SchemaFilter (config option)
      • UppercaseIdentifiers (config option)
    • Create Database
    • Data Source Name
    • Database
    • Description
    • Encryption Method
    • Fetch Size
    • Host Name
    • Host Name In Certificate
    • IANAAppCodePage
    • Initialization String
    • JVM Arguments
    • JVM Classpath
    • Key Password
    • Key Store
    • Key Store Password
    • Log Config File
    • Login Timeout
    • Min Long Varchar Size
    • Password
    • Port Number
    • Read Only
    • Read Preference
    • Report Codepage Conversion Errors
    • Result Memory Size
    • Schema Definition
    • Server Port Number
    • SQL Engine Mode
    • Transaction Mode
    • Trust Store
    • Trust Store Password
    • User Name
    • Validate Server Certificate
    • Varchar Threshold
  • Supported SQL statements
    • Delete
    • Insert
    • Refresh Map (EXT)
    • Reload Map (EXT)
    • Select
      • Select clause
        • Aggregate functions
        • From clause
          • Outer Join Escape Sequences
          • Join in a From Clause
          • Subquery in a From Clause
        • Where clause
        • Group By clause
        • Having clause
        • Union operator
        • Intersect operator
        • Except and Minus operators
        • Order By clause
        • Limit clause
    • Update
    • SQL expressions
      • Column names
      • Literals
        • Character string literals
        • Numeric literals
        • Binary literals
        • Date/Time literals
        • Integer literals
      • Operators
        • Unary operator
        • Binary operator
        • Arithmetic operators
        • Concatenation operator
        • Comparison operators
        • Logical operators
        • Operator precedence
      • Functions
      • Conditions
    • Subqueries
      • IN predicate
      • EXISTS predicate
      • UNIQUE predicate
      • Correlated subqueries
    • Custom function escapes
      • CAST_TO_NATIVE function escape
  • Copyright
Table of Contents

Mapping native objects in a schema

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: October 27, 2020
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • MongoDB 8.0
    • Documentation

After selecting an initial relational view of your data, you may want to map additional native objects to your schema definition. To map native objects in a schema, see the following topics:

Related Links
  • Mapping native objects
  • Mapping newly detected objects
TitleResults for “How to create a CRG?”Also Available inAlert