Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere 16 - Introduction » Data management technologies


ETL features

Extract, Transform, and Load (ETL) is the process by which large amounts of data is extracted from disparate data sources and consolidated into a single database. In the extraction phase, data is parsed and evaluated for suitability. During transformation, data is manipulated to achieve the format required for storage. Some common transformations include the elimination of unnecessary columns, calculation of computed values, and translation of values such as dates into a common format so that the data can be consolidated. The data is then loaded into the database at a frequency and scope consistent with the organization's needs.

SQL Anywhere offers several features in support of ETL. For example:

  • OPENSTRING operation   Use the OPENSTRING operation in the FROM clause to transform and load data from client- and server-side data sources. See FROM clause.

  • OPENXML operator   Use the OPENXML string operator to extract data from XML documents. See OPENXML operator.

  • MERGE statement   Use the MERGE statement to merge data from different source objects. See MERGE statement.

  • Proxy tables   Use proxy tables to access objects such as tables, views, and materialized views in a remote database. See Proxy tables.

  • System procedure calls in the FROM clause   You can use various system procedures in the FROM clause of a query to extract and transform data for loading. For a list of system procedures offered in SQL Anywhere, see System procedures.