Поддерживаемые базы данных

Инструкции для конкретной базы данных

Установка драйверов баз данных

Для корректной работы Fincomtech Analitics необходимо наличие соответствующего драйвера Python DB-API и диалекта SQLAlchemy для каждой системы управления базами данных (СУБД), к которой планируется подключение.

Поддерживаемые базы данных и зависимости

Ниже приведен список рекомендуемых пакетов. Информацию о версиях библиотек, совместимых с текущей сборкой Fincomtech Analitics, можно найти в файле pyproject.toml.

База данных	PyPI пакет	Строка подключения
AWS Athena	pip install pyathena[pandas] , pip install PyAthenaJDBC	awsathena+rest://{access_key_id}:{access_key}@athena.{region}.amazonaws.com/{schema}?s3_staging_dir={s3_staging_dir}&...
AWS DynamoDB	pip install pydynamodb	dynamodb://{access_key_id}:{secret_access_key}@dynamodb.{region_name}.amazonaws.com?connector=superset
AWS Redshift	pip install sqlalchemy-redshift	redshift+psycopg2://<userName>:<DBPassword>@<AWS End Point>:5439/<Database Name>
Apache Doris	pip install pydoris	doris://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>
Apache Drill	pip install sqlalchemy-drill	drill+sadrill://<username>:<password>@<host>:<port>/<storage_plugin>, often useful: ?use_ssl=True/False
Apache Druid	pip install pydruid	druid://<User>:<password>@<Host>:<Port-default-9088>/druid/v2/sql
Apache Hive	pip install pyhive	hive://hive@{hostname}:{port}/{database}
Apache Impala	pip install impyla	impala://{hostname}:{port}/{database}
Apache Kylin	pip install kylinpy	kylin://<username>:<password>@<hostname>:<port>/<project>?<param1>=<value1>&<param2>=<value2>
Apache Pinot	pip install pinotdb	pinot://BROKER:5436/query?server=http://CONTROLLER:5983/
Apache Solr	pip install sqlalchemy-solr	solr://{username}:{password}@{hostname}:{port}/{server_path}/{collection}
Apache Spark SQL	pip install pyhive	hive://hive@{hostname}:{port}/{database}
Arc - Apache Arrow	pip install arc-superset-arrow	arc+arrow://{api_key}@{hostname}:{port}/{database}
Arc - JSON	pip install arc-superset-dialect	arc+json://{api_key}@{hostname}:{port}/{database}
Ascend.io	pip install impyla	ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true
Azure MS SQL	pip install pymssql	mssql+pymssql://UserName@presetSQL:TestPassword@presetSQL.database.windows.net:1433/TestSchema
ClickHouse	pip install clickhouse-connect	clickhousedb://{username}:{password}@{hostname}:{port}/{database}
CockroachDB	pip install cockroachdb	cockroachdb://root@{hostname}:{port}/{database}?sslmode=disable
Couchbase	pip install couchbase-sqlalchemy	couchbase://{username}:{password}@{hostname}:{port}?truststorepath={ssl certificate path}
CrateDB	pip install sqlalchemy-cratedb	crate://{username}:{password}@{hostname}:{port}, often useful: ?ssl=true/false or ?schema=testdrive.
Denodo	pip install denodo-sqlalchemy	denodo://{username}:{password}@{hostname}:{port}/{database}
Dremio	pip install sqlalchemy_dremio	dremio+flight://{username}:{password}@{host}:32010, often useful: ?UseEncryption=true/false. For Legacy ODBC: dremio+pyodbc://{username}:{password}@{host}:31010
Elasticsearch	pip install elasticsearch-dbapi	elasticsearch+http://{user}:{password}@{host}:9200/
Exasol	pip install sqlalchemy-exasol	exa+pyodbc://{username}:{password}@{hostname}:{port}/my_schema?CONNECTIONLCALL=en_US.UTF-8&driver=EXAODBC
Google BigQuery	pip install sqlalchemy-bigquery	bigquery://{project_id}
Google Sheets	pip install shillelagh[gsheetsapi]	gsheets://
Firebolt	pip install firebolt-sqlalchemy	firebolt://{client_id}:{client_secret}@{database}/{engine_name}?account_name={name}
Hologres	pip install psycopg2	postgresql+psycopg2://<UserName>:<DBPassword>@<Database Host>/<Database Name>
IBM Db2	pip install ibm_db_sa	db2+ibm_db://
IBM Netezza Performance Server	pip install nzalchemy	netezza+nzpy://<UserName>:<DBPassword>@<Database Host>/<Database Name>
MySQL	pip install mysqlclient	mysql://<UserName>:<DBPassword>@<Database Host>/<Database Name>
OceanBase	pip install oceanbase_py	oceanbase://<UserName>:<DBPassword>@<Database Host>/<Database Name>
Oracle	pip install oracledb	oracle://<username>:<password>@<hostname>:<port>
Parseable	pip install sqlalchemy-parseable	parseable://<UserName>:<DBPassword>@<Database Host>/<Stream Name>
PostgreSQL	pip install psycopg2	postgresql://<UserName>:<DBPassword>@<Database Host>/<Database Name>
Presto	pip install pyhive	presto://{username}:{password}@{hostname}:{port}/{database}
SAP Hana	pip install hdbcli sqlalchemy-hana or pip install apache_superset[hana]	hana://{username}:{password}@{host}:{port}
SingleStore	pip install sqlalchemy-singlestoredb	singlestoredb://{username}:{password}@{host}:{port}/{database}
StarRocks	pip install starrocks	starrocks://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>
Snowflake	pip install snowflake-sqlalchemy	snowflake://{user}:{password}@{account}.{region}/{database}?role={role}&warehouse={warehouse}
SQLite	Никакой дополнительной библиотеки не требуется	sqlite://path/to/file.db?check_same_thread=false
SQL Server	pip install pymssql	mssql+pymssql://<Username>:<Password>@<Host>:<Port-default:1433>/<Database Name>
TDengine	pip install taospy pip install taos-ws-py	taosws://<user>:<password>@<host>:<port>
Teradata	pip install teradatasqlalchemy	teradatasql://{user}:{password}@{host}
TimescaleDB	pip install psycopg2	postgresql://<UserName>:<DBPassword>@<Database Host>:<Port>/<Database Name>
Trino	pip install trino	trino://{username}:{password}@{hostname}:{port}/{catalog}
Vertica	pip install sqlalchemy-vertica-python	vertica+vertica_python://<UserName>:<DBPassword>@<Database Host>/<Database Name>
YDB	pip install ydb-sqlalchemy	ydb://{host}:{port}/{database_name}
YugabyteDB	pip install psycopg2	postgresql://<UserName>:<DBPassword>@<Database Host>/<Database Name>