Load Ingest Data
Results 1 to 4 of 4

Thread: What are the capabilities of an Attunity virtual database?

  1. #1
    Customers Ask is offline Our customers questions
    Join Date
    Aug 2006
    Posts
    15
    Rep Power
    0

    What are the capabilities of an Attunity virtual database?

    What are the main features of virtual databases?

  2. #2
    Andre is offline Documentation Manager
    Join Date
    Aug 2006
    Posts
    147
    Rep Power
    14

    Cool

    An AIS virtual database:

    • Presents a view to the user such that only selected tables from either one or more data sources are available, as if from a single data source.
    • Limits the data available to a user to the tables and views that are needed by that user.
    • Presents table names in a meaningful way, by defining the name as used by a data source with a name that has meaning in the Application.
    • Enables an application to view the tables in several data sources in a uniform manner, by presenting a consistent view of each table in the virtual database.


    AIS provides a mechanism that enables the user to create and access a single virtual database. A virtual database consists of selected tables and views from other Attunity Connect data sources. To the calling application, a virtual database looks like a single database with a predefined set of tables and views. The calling application cannot access the underlying sources, which prevents access to other corporate data.

    A virtual database can also be used to provide more meaningful names for tables and views. Because the virtual database uses a Repository to maintain its definitions, native system constraints on file and table names do not apply. This feature is particularly useful for legacy back end databases whose table/record names are restricted by the naming conventions of the backend platforms (for example, the eight-character limit on HP NonStop computers).

  3. #3
    knewman is offline Junior Member
    Join Date
    Jan 2012
    Posts
    17
    Rep Power
    0
    Can you write to a virtual database?

  4. #4
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    Yes - at least to object that are synonyms for tables in other data sources.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •