Accessing data sources by using IBM Cloud Satellite connectors in Data Virtualization

About this task

Copy link to section

IBM Cloud Satellite Connectors enable you to securely connect to your on-premises data sources. To establish a IBM Cloud Satellite Connector connection, you must create a IBM Cloud Satellite Connector in IBM Cloud, set up IBM Cloud Satellite agents, and then create a new connection in Data Virtualization or import an existing platform connection that was created by using IBM Cloud Satellite Connector.

For more information on IBM Cloud Satellite Connectors, see IBM Cloud Satellite Connector overview.

Before you begin

Copy link to section

• To access IBM Cloud Satellite connector services from Data Virtualization, you need the Satellite Link Administrator service role and Viewer platform role for IBM Cloud Satellite.

  For more information, see Platform roles and Service roles in IAM platform and service access roles.

• To create a IBM Cloud Satellite Connector connection, you need the Administrator platform role for IBM Cloud Satellite.

• To connect an agent to an existing connector, you need the Viewer platform role for IBM Cloud Satellite.

  For more information, see IBM Cloud IAM roles.

Procedure

Copy link to section

1. In IBM Cloud, select Satellite > Connectors then select your region.
2. Select Create Connector and then name the connector.
3. Select Create to create a IBM Cloud Satellite Connector.
4. Create a IBM Cloud Satellite agent by completing the steps in Running a Connector agent.
5. Create a IBM Cloud Satellite Connector connection from Data Virtualization or by importing an existing platform connection.
   • To create a connection from Data Virtualization, complete the following steps.
     1. In Data Virtualization, navigate to the Data sources page and then select Add connection > New connection.
     2. Select the on-premises data source that you want your IBM Cloud Satellite Connector to connect to.
     3. Enter the following information:
        • Name of the connection
        • Hostname or IP address of the connection
        • Port number
        • Database name
        • Username
        • Password
     4. In Private connectivity, select IBM Cloud Satellite, and then select the name of your connector.
     5. Select Create.
     6. Optional: If you want to add another IBM Cloud Satellite Connector, then navigate to Private connector and select the connector you want to add.
        Note: This option lets you bypass the endpoint creation limit for each connector. If you have more than 13 data sources, then you need to create another connector, and then add it through the Add collaborators and add the connection to a remote connector page.
     7. Select Continue.
     8. Your data source connection now appears in the Data sources page under the Table view.
   • To create a connection by importing an existing platform connection, complete the following steps.
     1. In IBM Cloud Pak for Data, navigate to Platform connections.
     2. Select the connector for creating a data source connection.
     3. Enter the following information:
        • Name of the connection
        • Hostname or IP address of the connection
        • Port number
        • Database name
        • Username
        • Password
     4. In Private connectivity, select IBM Cloud Satellite, and then select the name of your connector.
     5. Select Create.
     6. In the Data sources page, select Add connection > Existing platform connection > Continue.
     7. Select the data source that you want to add, and then select Add.
     8. Optional: If you want to add another IBM Cloud Satellite Connector, then navigate to Private connector and select the connector you want to add.
        Note: This option lets you bypass the endpoint creation limit for each connector. If you have more than 13 data sources, then you need to create another connector, and then add it through the Add collaborators and add the connection to a remote connector page.
     9. Select Continue.
     10. Your data source connection now appears in the Data sources page under the Table view.