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:
- JDBC Data Sources
- ODBC Data Sources
- Multidimensional Data Sources
- Data Sources for SOAP Web Services
- XML Data Sources
- JSON Sources
- DF Data Sources
- LDAP Data Sources
- BAPI Data Sources
- Salesforce Data Sources
- MongoDB Data Sources
- Custom Data Sources
- Data Source Configuration Properties
- Specifying Paths in Virtual DataPort
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 | MONGODB | ODBC | OLAP
| SALESFORCE | SAPBWBAPI | SAPERP | WS | XML
Example¶
RENAME DATA SOURCE JDBC ds_snowflake TO ds_jdbc_snowflake;