edit-icon download-icon

Get started with DLA

Last Updated: Jan 29, 2019

This topic describes how to quickly get started with Data Lake Analytics (DLA). If you have successfully subscribed and activated DLA service, you can skip steps 1 and 2.

Step 1: Subscribe to DLA

Click Activate Now to subscribe to DLA.

image.png | left | 827x352

Step 2: Activate your DLA account

Click DLA Console to access the DLA admin console.

image.png | left | 827x333

Enter an initial service account password that complies to the password conventions, or use a password randomly generated by the system.

Check the Alibaba Cloud Message Center to obtain your credentials.

image.png | left | 827x185

Step 3: Grant DLA permission to access OSS

On the Overview tab page of the DLA console, click the OSS button, and then click Confirm Authorization Policy.

image.png | left | 827x235

After you click the Confirm Authorization, the browser returns to the DLA console.

Step 4: Grant DLA permission to access Table Store

On the DLA console, click theTable Store button, and click Confirm Authorization Policy.

After you Confirm Authorization Policy , the browser returns to the DLA admin console.

Step 5: Create endpoint

On the DLA console click Create Endpoint.

Choose Set IP Access Whitelist to create a classic network access endpoint. You must specify the IP whitelist for your access endpoint.

image.png | left | 377x212

Note: The IP whitelist supported IP segment configurations include CIDR X.X.X.X/X or X.X.X.X. Configuring the IP whitelist address to 0.0.0.0/0 allows access from all network addresses. IP addresses must be unique and separated by commas (,).

Or choose Create VPC Network to create an access endpoint (single tunnel) that only allows access from the specified VPC. If you have multiple VPC, you can create access endpoints for each VPC.

image.png | left | 375x284

Afterwards, all endpoints are listed in the Endpoint section.

image.png | left | 827x127

Step 6: Log on to the DMS console

Click Log On to DMS Console to log on to DMS console for SQL operation.

image.png | left | 827x136

Make sure the region and endpoint are correct for this region, and enter the DLA service account username and password received in Step 2 and click Login.

image.png | left | 456x349

Then you can perform SQL operation in the DMS console. (Note that if your DMS service is deployed in the Singapore region, you must go to Step 7 to enable MySQL client access.)

image.png | left | 827x164

Step 7: Use MySQL client to connect to DLA

In addition to the DMS console shown in Step 6, DLA is compatible with most MySQL database sources and tools, and standard Business Intelligence (BI) software. DLA supports any JDBC or ODBC connections, including but not limited to, other MySQL clients and BI tools (Tableau, Qlik, and others). (Currently, MySQL 8.0 protocol is not supported. Please use the Suggested Version detailed in the following table.)

Tooling Download Suggested Version
MySQL Shell https://www.mysql.com/downloads/ 5.5.x, 5.6.x, 5.7.x
MySQL Workbench https://www.mysql.com/products/workbench/ 6.3
DBeaver https://github.com/dbeaver/dbeaver 4.2.5
SQL Workbench/J https://www.sql-workbench.eu/ Build 124
Sequel Pro http://sequelpro.com/ 1.1.2
Navicat for MySQL https://www.navicat.com/en/download/navicat-for-mysql 12.1.8

You can access DLA over the Internet. Note that the username and password obtained from Step 2 are required to connect to DLA through JDBC or ODBC.

1) Connect with MySQL shell:

  1. mysql -hxxxxx.datalakeanalytics.aliyuncs.com -P10000 -uuser_name -p -c -A

user_name refers to your DLA account username. Provide DLA account password afterwards.

image.png | left | 827x165

2) Connect with MySQL Workbench:

Choose Setup New Connection.

image.png | left | 827x623

3) Connect with DBeaver:

Choose Create new connection.

image.png | left | 650x483

4) Connect with SQL Workbench/J:

Connect through MySQL JDBC driver.

image.png | left | 777x491

5) Connect with Sequel Pro:

Choose QUICK CONNECT or add your required connection.

image.png | left | 763x622

6) Connect with Navicat for MySQL:

Choose MySQL to add a new connection.

image.png | left | 623x554

Appendix: Syntax References

Thank you! We've received your feedback.