Adding data sources (Data Virtualization)
Data Virtualization supports many relational and non-relational data sources that you can add to your data source environment. Data Virtualization connects to relational data sources by using the Java Database Connectivity (JDBC) protocol.
Before you begin
Review the list of data sources that are supported for Data Virtualization by viewing the Virtualize column in Supported data sources.
After a data source is added, any user with virtualize permissions (Data Virtualization Admin or Engineer roles) can create virtual tables. The user can create virtual tables by using any of the added data sources, no matter which user added the data source. Users with a Data Virtualization User role must be granted access to the virtualized table or view by using the data request workflow. For more information, see Managing users and roles.
Data Virtualization supports the PEM certificate format only for SSL/TLS-enabled data sources.
There are special steps that are involved in adding certain data sources, such as SAP HANA and Snowflake.
Adding new data source
About this task
To add a data source to your environment, complete the following steps:
Procedure
Adding a data source from existing connection
About this task
To add a data source from an existing connection, complete the following steps:
Procedure
- Click .
- Click the Add data source drop-down menu and click Select existing connection to see a list of data sources that can be added to Data Virtualization.
- Select the data source that you want to add and click Add.
- Optional: Select a remote connector to associate to the data source and click
Add to connector. For more information, see Installing remote connectors.