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
    Rep Power

    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
    Rep Power


    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
    Rep Power
    Can you write to a virtual database?

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

    To Find Out more About Attunity Technology:
    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