数据源
Alteryx 可连接到各种数据源。Alteryx 可以读取、写入或读取且写入,具体取决于数据源。
受支持的数据源和文件格式
Adobe | 只读 | ||
Alteryx | .yxdb | 读取、写入 | |
Alteryx Calgary | .cydb | 只读 | |
Alteryx Spatial ZIP | .sz | 读取、写入 | |
Amazon | 读取、写入(仅批量) | ||
读取、写入 | |||
读取、写入、数据库内 | |||
读取、写入 | |||
读取、写入 | |||
Anaplan | .csv、.xlsx、.txt | 读取、写入 | |
ASCII | .flat | 读取、写入 | |
Apache | 读取、写入、数据库内 | ||
读取、写入、数据库内 | |||
读取、写入、数据库内 | |||
读取、写入、数据库内 | |||
.avro | 读取、写入 | ||
读取、写入 | |||
读取、写入、数据库内 | |||
读取、写入、数据库内 | |||
读取、写入 | |||
Automation Anywhere | 只读 | ||
Box | .xlsx、.yxdb、.csv | 读取、写入 | |
CSV | Comma Separated Value | .csv | 读取、写入 |
Databricks | 读取、写入、数据库内 | ||
读取、写入、数据库内 | |||
数据库内写入 | |||
Denodo | 读取、写入、数据库内 | ||
Dremio | 只读 | ||
Dropbox | .xlsx、.yxdb、.csv | 读取、写入 | |
dBase | dBase | .dbf | 读取、写入 |
ESRI | . gdb | 读取、写入 | |
ESRI Personal GeoDatabase | mdb | 只读 | |
ESRI Shapefile | .shp | 读取、写入 | |
EXASOL | 读取、写入、数据库内 | ||
GIS | GIS | .grc, .grd | 只读 |
只读 | |||
读取、写入、数据库内 | |||
Google Earth/Google Maps | .kml | 读取、写入 | |
.xlsx、.yxdb、.csv、.gsheet | 读取、写入 | ||
读取、写入 | |||
Gzip | .gz, .tgz | 只读 | |
HTML | HyperText Markup Language | .htm | 只写 |
IBM | 读取、写入 | ||
读取、写入、数据库内 | |||
.sav | 读取、写入 | ||
JSON | JSON | .json | 读取、写入 |
MapInfo | MapInfo Professional 数据交换格式 | .mif | 读取、写入 |
MapInfo Professional 表格 - 经典 TAB 格式 | .tab | 读取、写入 | |
MapR | 读取、写入 | ||
读取、写入、数据库内 | |||
Marketo | 读取、写入 | ||
Microsoft | Microsoft Access 2000-2003 | .mdb | 读取、写入 |
读取、写入、数据库内 | |||
读取、写入 | |||
读取、写入、数据库内 | |||
Microsoft Azure SQL Data Warehouse (Azure Synapse Analytics) | 读取、写入、数据库内 | ||
只读 | |||
读取、写入 | |||
读取、写入 | |||
Microsoft Excel 1997-2003 | .xls | 读取、写入 | |
.xlsx | 读取、写入 | ||
Microsoft Excel 二进制文档 | .xlsb | 读取、写入 | |
Microsoft Excel Macro Enabled | .xlsm | 读取、写入 | |
.accdb、.accde | 读取、写入 | ||
只读 | |||
读取、写入 | |||
只写 | |||
读取、写入 | |||
读取、写入、数据库内、空间 | |||
MongoDB | 读取、写入 | ||
MySQL | 读取、写入、数据库内、空间 | ||
NetSuite | 只读 | ||
OpenGIS | Geography Markup Language | .gml | 只写 |
Oracle | 读取、写入、数据库内、预测、空间(仅适用于 OCI) | ||
| parquet、.pqt | 读取、写入 | |
Pivotal | 读取、写入、数据库内 | ||
PostgreSQL | 读取、写入、数据库内、空间(使用 PostGIS) | ||
PrestoDB | 读取、写入 | ||
Qlik | QlikView | .qvx | 读取、写入 |
Salesforce | 读取、写入 | ||
SAP | 读取、写入、数据库内 | ||
读取、写入 | |||
SAS | .sas7bdat | 读取、写入 | |
ServiceNow | 只读 | ||
Snowflake | 读取、写入、数据库内 | ||
SQLite | SQLite | .sqlite | 读取、写入 |
SRC Geography | SRC Geography | .geo | 读取、写入 |
Tableau | .hyper | 读取、写入 | |
Teradata | 读取、写入、数据库内 | ||
只读 | |||
Trino | 读取、写入(仅限实例化表格) | ||
文本 | 文本 | .txt, .asc | 只读 |
Vertica | 读取、写入、数据库内 | ||
UiPath | |||
XML | .xml | 只读 | |
Zip Files | .zip | 只读 |
已弃用的数据源和工具
尽管我们已弃用且不再支持这些连接器,但您仍然可以在 Designer 或 Server 中使用。如果要显示隐藏的图标,请右键单击工具功能区,然后选择显示已弃用的工具。但是,我们建议安装新的替换工具。如需了解详情,请访问社区文章。
弃用的工具 | 新工具 |
---|---|
Sharepoint 列表 | |
注意
With Designer version 24.1, the default DCM mode is DCM Only. This means that the checkbox to Use DCM on tool configurations might no longer be visible by default. You can still change the DCM Mode in the System Settings or User Settings.
This change doesn’t override your previously configured DCM settings. It only applies to new Designer installs as well as installs where DCM settings have not been previously configured.Go to DCM - Designer for more information.