Creating Data Sources

In Virtual DataPort, wrappers are associated to data sources. Data sources encapsulate the configuration needed to access a certain data repository (e.g. a database, a Web service, etc.)

The following sections describe the manual creation process for each data source type:

Note

We strongly recommended creating wrappers and data sources using the Virtual DataPort Administration Tool because doing it with VQL statements is more difficult and prone to errors.

To rename a data source, use the statement RENAME:

Syntax of the statement RENAME DATA SOURCE
RENAME DATA SOURCE <data source type> <name:identifier> TO <new name:identifier>

<data source type> ::=
    CUSTOM | DF | ESSBASE | JDBC | JSON | LDAP | ODBC | OLAP
  | SALESFORCE | SAPBWBAPI | SAPERP | WS | XML
Example
RENAME DATA SOURCE JDBC ds_snowflake TO ds_jdbc_snowflake;