# DLI常用跨源分析开发方式 #### 跨源分析 当DLI有访问外部数据源的业务需求时，首先需要通过建立增强型跨源连接，打通DLI与数据源之间的网络，再开发不同的作业访问数据源以实现DLI跨源分析。 本节操作介绍DLI支持的数据源对应的开发方式。 #### 使用须知 - Flink作业访问DIS，OBS和SMN数据源，无需创建跨源连接，可以直接访问。 - 推荐使用增强型跨源连接打通DLI与数据源之间的网络。 #### 跨源分析开发方式 [表1]提供DLI支持的数据源对应的开发方式。 表1跨源分析语法参考 | 服务名称 | 开发SQL作业 | 开发Spark jar作业 | 开发Flink OpenSource SQL作业 | 开发Flink Jar作业 | |:---|:---|:---|:---|:---| | CloudTable HBase | - [创建HBase关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0119.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0120.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0121.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0063.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0078.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0197.html) | - [Hbase源表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0384.html) - [Hbase结果表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0396.html) - [Hbase维表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0404.html) | - | | CloudTable OpenTSDB | - [创建OpenTSDB关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0122.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0123.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0124.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0065.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0081.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0193.html) | - | - | | CSS | - [创建CSS关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0201.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0202.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0203.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0061.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0090.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0190.html) | - [Elasticsearch结果表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0395.html) | - | | DCS Redis | - [创建DCS关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0226.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0227.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0228.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0094.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0097.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0100.html) | - [Redis源表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0389.html) - [Redis结果表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0400.html) - [Redis维表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0406.html) | - [Flink作业样例](https://support.huaweicloud.com/devg-dli/dli_09_0150.html) | | DDS | - [创建DDS关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0230.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0231.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0232.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0114.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0117.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0110.html) | - | **-** | | DMS | - | - | - [Kafka源表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0386.html) - [Kafka结果表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0398.html) | - | | DWS | - [创建DWS关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0193.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0194.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0195.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0069.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0087.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0199.html) | - [DWS源表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0383.html) - [DWS结果表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0394.html) - [DWS维表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0403.html) | - [Flink作业样例](https://support.huaweicloud.com/devg-dli/dli_09_0150.html) | | MRS HBase | - [创建HBase关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0119.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0120.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0121.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0063.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0078.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0197.html) | - [Hbase源表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0384.html) - [Hbase结果表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0384.html) - [Hbase维表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0404.html) | - [Flink作业样例](https://support.huaweicloud.com/devg-dli/dli_09_0150.html) | | MRS Kafka | - | - | - [Kafka源表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0386.html) - [Kafka结果表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0398.html) | - [Flink作业样例](https://support.huaweicloud.com/devg-dli/dli_09_0150.html) | | MRS OpenTSDB | - [创建OpenTSDB关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0122.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0123.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0124.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0065.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0081.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0193.html) | - | - | | RDS MySQL | - [创建RDS关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0197.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0198.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0199.html) | - [scala样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0067.html) - [pyspark样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0084.html) - [java样例代码](https://support.huaweicloud.com/devg-dli/dli_09_0187.html) | - [MySQL CDC源表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0387.html) | - | | RDS PostGre | - [创建RDS关联表](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0197.html) - [插入数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0198.html) - [查询数据](https://support.huaweicloud.com/sqlref-spark-dli/dli_08_0199.html) | - | - [Postgres CDC源表](https://support.huaweicloud.com/sqlref-flink-dli/dli_08_0388.html) | - |