Google Workspace
Google Workspace is a productivity toolkit. You can use Google Workspace as a data source when landing or replicating data.
-
有关连接 SaaS 应用程序的更多信息,请参阅连接到 SaaS 应用程序。
-
必须安装 数据移动网关 才能移动 SaaS 应用程序中的数据。有关更多信息,请参阅Qlik 数据网关 - 数据移动。
Supported update methods
For more information, see 更改处理.
Landing tasks:
-
Reload and compare
Replication tasks:
-
Full load
Landing data in a data lake tasks:
-
Reload
Preparing for authentication
To access your Google Workspace data, you need to authenticate the connection with your account credentials.
-
Navigate to https://console.cloud.google.com/iam-admin/serviceaccounts.
Select your project, or create a new project.
-
Click Create service account, and name the account Qlik.
Click Create, then click Done.
-
Click Qlik, then click Show domain wide delegation.
Click Enable G Suite Domain-wide Delegation, then click Save.
-
Click Keys, then click Add key.
Click Create new key, click Create, then click Close.
This will create a service account key file that you will need when creating the connection.
-
Click Details, and copy the value in Unique ID.
-
Navigate to https://admin.google.com.
Click Security, then scroll down and click API controls.
-
Click Manage domain wide delegation, then click Add new.
Paste the id you copied from Unique ID into the Client ID field.
Set scopes to the following:
https://www.googleapis.com/auth/admin.directory.user,https://www.googleapis.com/auth/admin.directory.user.alias,https://www.googleapis.com/auth/calendar,https://www.googleapis.com/auth/admin.directory.group,https://www.googleapis.com/auth/drive,https://mail.google.com/
-
Click Authorize.
Enter your domain name and admin email address, and click Add.
You will need the domain name and admin email address when creating the connection.
Creating the connection
- Fill in the required connection properties.
-
Provide a name for the connection in Connection name.
-
Select Open connection metadata to define metadata for the connection when it has been created.
-
Click Create.
Setting | Description |
---|---|
Data gateway |
选择要在复制数据时使用的 数据移动网关。 |
Service Account Key |
Upload the file with the service account key that was created when preparing. |
Admin email address | The admin email you entered when authorizing. |
GSuite Domain | The domain name you entered when authorizing. |