# 3rd-Party Integrations

**URL:** https://www.singlestore.com/forum/c/integrations/23.md

[Latest](https://www.singlestore.com/forum/latest.md) · [Categories](https://www.singlestore.com/forum/categories.md) · [Tags](https://www.singlestore.com/forum/tags.md)

---

## [About the 3rd-Party Integrations category](https://www.singlestore.com/forum/t/about-the-3rd-party-integrations-category/52)

<div class="topic-metadata">

**Author:** [@memsqlpubs](https://www.singlestore.com/forum/u/memsqlpubs)\
**Replies:** 0

</div>

Have a question about 3rd-Party Integrations? SingleStore makes integrations easy, but it’s ok to ask for more help. This category is for discussing partner tools and frameworks that connect and work with SingleStore.

---

## [ELT tool recommendations?](https://www.singlestore.com/forum/t/elt-tool-recommendations/3304)

<div class="topic-metadata">

**Author:** [@christoph](https://www.singlestore.com/forum/u/christoph)\
**Replies:** 4\
**Last updated:** [September 30, 2024, 4:21pm UTC](https://www.singlestore.com/forum/t/elt-tool-recommendations/3304 "2024-09-30T16:21:33Z")

</div>

Dear community, We are currnetly using Microsoft SQL Server Integration Services (SSIS) to manage our ELT workloads but are curious what you are using and if you have some recomendations. We really just have one requir…

---

## [Power BI Connector](https://www.singlestore.com/forum/t/power-bi-connector/1927)

<div class="topic-metadata">

**Author:** [@moralez.rodrigo](https://www.singlestore.com/forum/u/moralez.rodrigo)\
**Replies:** 31\
**Last updated:** [May 6, 2024, 8:12am UTC](https://www.singlestore.com/forum/t/power-bi-connector/1927 "2024-05-06T08:12:56Z")

</div>

The Direct query is not working when I use this connector: I’m getting OLE DB or ODBC error: \[Expression.Error\] The value provided for SQL capability ‘FractionalSecondsScale’ in Odbc.DataSource is invalid error. Is …

---

## [Developer webinar: SingleStore and Agile Digital Twins from Hopara](https://www.singlestore.com/forum/t/developer-webinar-singlestore-and-agile-digital-twins-from-hopara/6998)

<div class="topic-metadata">

**Author:** [@ksmith](https://www.singlestore.com/forum/u/ksmith)\
**Replies:** 0\
**Last updated:** [July 23, 2023, 4:59pm UTC](https://www.singlestore.com/forum/t/developer-webinar-singlestore-and-agile-digital-twins-from-hopara/6998 "2023-07-23T16:59:47Z")

</div>

Digital Transformation and Digital Twins have revolutionized the way companies leverage their data. Join us at \[Hopara, Inc.\] upcoming webinar where we’ll introduce Agile Digital Twin (ADT) - developed at MIT’s AI Lab (…

---

## [Integrating SSDB with Agile Digital Twins](https://www.singlestore.com/forum/t/integrating-ssdb-with-agile-digital-twins/6955)

<div class="topic-metadata">

**Author:** [@ksmith](https://www.singlestore.com/forum/u/ksmith)\
**Replies:** 0\
**Last updated:** [July 6, 2023, 3:44pm UTC](https://www.singlestore.com/forum/t/integrating-ssdb-with-agile-digital-twins/6955 "2023-07-06T15:44:21Z")

</div>

Instructional webinar for SingleStore Developers- integrating a SSDB with an Agile Digital Twin: Free sign up at: https://hopara.io/singlestore-and-hopara/

---

## [Django, installation not working with single store db](https://www.singlestore.com/forum/t/django-installation-not-working-with-single-store-db/4434)

<div class="topic-metadata">

**Author:** [@g.shireesh.kumar](https://www.singlestore.com/forum/u/g.shireesh.kumar)\
**Replies:** 2\
**Last updated:** [June 21, 2023, 3:17pm UTC](https://www.singlestore.com/forum/t/django-installation-not-working-with-single-store-db/4434 "2023-06-21T15:17:20Z")

</div>

I am unable to connect memsql to django with mysql db connector.

---

## [Prometheus/Grafana dashboards and alerts?](https://www.singlestore.com/forum/t/prometheus-grafana-dashboards-and-alerts/3293)

<div class="topic-metadata">

**Author:** [@garret.coffman](https://www.singlestore.com/forum/u/garret.coffman)\
**Replies:** 10\
**Last updated:** [June 2, 2023, 12:43am UTC](https://www.singlestore.com/forum/t/prometheus-grafana-dashboards-and-alerts/3293 "2023-06-02T00:43:38Z")

</div>

We’ve implemented a Prometheus/Grafana/Thanos monitoring setup here and are scraping metrics from our Singlestore clusters using the integrated exporter and promtheus. I’ve been looking at the documentation and found so…

---

## [Extremely slow BACKUP query with S3 storage](https://www.singlestore.com/forum/t/extremely-slow-backup-query-with-s3-storage/6657)

<div class="topic-metadata">

**Author:** [@miguilim](https://www.singlestore.com/forum/u/miguilim)\
**Replies:** 8\
**Last updated:** [April 13, 2023, 8:44pm UTC](https://www.singlestore.com/forum/t/extremely-slow-backup-query-with-s3-storage/6657 "2023-04-13T20:44:10Z")

</div>

Hello, I’m trying to use the BACKUP command with the INIT option (for later incremental) to an S3 storage, but the query runs extremely slow. My database has a size of 50 GB compressed. The query uploads about to ~4 GB …

---

## [Could not insert via LinkedServer (Sql Server)](https://www.singlestore.com/forum/t/could-not-insert-via-linkedserver-sql-server/6651)

<div class="topic-metadata">

**Author:** [@twu](https://www.singlestore.com/forum/u/twu)\
**Replies:** 0\
**Last updated:** [March 29, 2023, 11:21pm UTC](https://www.singlestore.com/forum/t/could-not-insert-via-linkedserver-sql-server/6651 "2023-03-29T23:21:31Z")

</div>

I’ve setup SingleStore db as a linkedserver in our Sql server and no issues with Select queries. however we could not insert anything into any table. just wondering if this is supported by the official ODBC driver or pe…

---

## [Testers / pilot projects wanted for new software package from MIT](https://www.singlestore.com/forum/t/testers-pilot-projects-wanted-for-new-software-package-from-mit/6381)

<div class="topic-metadata">

**Author:** [@ksmith](https://www.singlestore.com/forum/u/ksmith)\
**Replies:** 1\
**Last updated:** [January 18, 2023, 2:46am UTC](https://www.singlestore.com/forum/t/testers-pilot-projects-wanted-for-new-software-package-from-mit/6381 "2023-01-18T02:46:40Z")

</div>

We are a new Ecosystem Partner now live on SingleStore Connect (https://connect.singlestore.com/en-US/apps/401102). This is a new software platform developed at MIT CSAIL for enahancing visualization of big / real time …

---

## [How can I create an ERD by reverse engineering and exisitng DB](https://www.singlestore.com/forum/t/how-can-i-create-an-erd-by-reverse-engineering-and-exisitng-db/3614)

<div class="topic-metadata">

**Author:** [@claire.moore](https://www.singlestore.com/forum/u/claire.moore)\
**Replies:** 4\
**Last updated:** [January 11, 2023, 6:36pm UTC](https://www.singlestore.com/forum/t/how-can-i-create-an-erd-by-reverse-engineering-and-exisitng-db/3614 "2023-01-11T18:36:09Z")

</div>

Hi Folks, I want to create an ERD for our existing Singlestore DB. Can anyone recommend a tool that will help me do this? I tried Sql Workbench --\> Database --\> Reverse Engineer but it bombs when I try to select tables. …

---

## [What analytics tool are you using?](https://www.singlestore.com/forum/t/what-analytics-tool-are-you-using/3780)

<div class="topic-metadata">

**Author:** [@stefandevo](https://www.singlestore.com/forum/u/stefandevo)\
**Replies:** 2\
**Last updated:** [January 4, 2023, 2:20pm UTC](https://www.singlestore.com/forum/t/what-analytics-tool-are-you-using/3780 "2023-01-04T14:20:50Z")

</div>

One of the reasons to choose for SingleStore was the real time analytics option. Now we are looking for a user friendly BI tool that can work on real time SingleStore data (a lot of tools take copies/snapshots of the da…

---

## [SAP Data services integration with SingleStore](https://www.singlestore.com/forum/t/sap-data-services-integration-with-singlestore/5425)

<div class="topic-metadata">

**Author:** [@e.soden](https://www.singlestore.com/forum/u/e.soden)\
**Replies:** 4\
**Last updated:** [September 29, 2022, 7:29am UTC](https://www.singlestore.com/forum/t/sap-data-services-integration-with-singlestore/5425 "2022-09-29T07:29:08Z")

</div>

Dears, We are using SAP Data services to replicate data to SingleStore database. Actually, most of our test is working fine. But we have found one issue when SAP Data services is trying to make a Delta Load. When tabl…

---

## [Direct load feature from singlestore to s3 bucket](https://www.singlestore.com/forum/t/direct-load-feature-from-singlestore-to-s3-bucket/5156)

<div class="topic-metadata">

**Author:** [@sairohith2012](https://www.singlestore.com/forum/u/sairohith2012)\
**Replies:** 1\
**Last updated:** [September 14, 2022, 6:14pm UTC](https://www.singlestore.com/forum/t/direct-load-feature-from-singlestore-to-s3-bucket/5156 "2022-09-14T18:14:00Z")

</div>

Hi Team, I am planning to use the direct load feature from singlestore to s3. Would like to understand more on how it’s implemented. Are there any resources I can go through. Thanks, Rohith

---

## [Access denied on mysqldump connect](https://www.singlestore.com/forum/t/access-denied-on-mysqldump-connect/5031)

<div class="topic-metadata">

**Author:** [@attila.dobos](https://www.singlestore.com/forum/u/attila.dobos)\
**Replies:** 5\
**Last updated:** [September 9, 2022, 7:57pm UTC](https://www.singlestore.com/forum/t/access-denied-on-mysqldump-connect/5031 "2022-09-09T19:57:20Z")

</div>

Dear Support & All, I have been trying to implement a solution which involves dumping a database from our SingleStore cluster. I have tried using mysql client on Windows and MariaDB client on Ubuntu. mysqldump --host …

---

## [Prometheus Full Setup yml file](https://www.singlestore.com/forum/t/prometheus-full-setup-yml-file/3950)

<div class="topic-metadata">

**Author:** [@vasanth.ramu](https://www.singlestore.com/forum/u/vasanth.ramu)\
**Replies:** 3\
**Last updated:** [May 17, 2022, 2:43am UTC](https://www.singlestore.com/forum/t/prometheus-full-setup-yml-file/3950 "2022-05-17T02:43:33Z")

</div>

Hi, We are looking for a typical and important SingleStore alerting prometheus\_rules.yml . Confused a lot with so many things exposed from the exporter. Table Memory is easy to monitor, but events like memsql\_event\_MAX…

---

## [Scaffold-DbContext for Singlestore. (Scaffolding, Reverse Engineering)](https://www.singlestore.com/forum/t/scaffold-dbcontext-for-singlestore-scaffolding-reverse-engineering/3708)

<div class="topic-metadata">

**Author:** [@NetDev](https://www.singlestore.com/forum/u/NetDev)\
**Replies:** 2\
**Last updated:** [March 30, 2022, 3:37pm UTC](https://www.singlestore.com/forum/t/scaffold-dbcontext-for-singlestore-scaffolding-reverse-engineering/3708 "2022-03-30T15:37:30Z")

</div>

Hello, Within a .NET 6 API, we would like to scaffold a database into C# objects. You can achieve this with Scaffold-DbContext using a library provided by CData, but this library costs $800 a year. Is there a way to sca…

---

## [Adapter for DBT?](https://www.singlestore.com/forum/t/adapter-for-dbt/3457)

<div class="topic-metadata">

**Author:** [@crtomir](https://www.singlestore.com/forum/u/crtomir)\
**Replies:** 8\
**Last updated:** [January 29, 2022, 1:41am UTC](https://www.singlestore.com/forum/t/adapter-for-dbt/3457 "2022-01-29T01:41:07Z")

</div>

Is there a plan to support an adapter for DBT? With SingleStore supporting analytics and DBT getting more and more popular for data transformation, I think it would be a smart move to provide a “vendor-supported” adapter…

---

## [SingleStore stream out to only one Kafka Partition](https://www.singlestore.com/forum/t/singlestore-stream-out-to-only-one-kafka-partition/3751)

<div class="topic-metadata">

**Author:** [@niro](https://www.singlestore.com/forum/u/niro)\
**Replies:** 2\
**Last updated:** [January 23, 2022, 4:42pm UTC](https://www.singlestore.com/forum/t/singlestore-stream-out-to-only-one-kafka-partition/3751 "2022-01-23T16:42:38Z")

</div>

Hi, I know there is a way to stream data out from Memsql to Kafka topic using select ... into kafka, but I was wondering how the data produce stream is implemented. I try to stream out the data from SingleStore using: …

---

## [Access denied for user 'distributed'@'IP' (using password: YES)](https://www.singlestore.com/forum/t/access-denied-for-user-distributed-ip-using-password-yes/3498)

<div class="topic-metadata">

**Author:** [@emanuelbesliu](https://www.singlestore.com/forum/u/emanuelbesliu)\
**Replies:** 10\
**Last updated:** [January 18, 2022, 10:31am UTC](https://www.singlestore.com/forum/t/access-denied-for-user-distributed-ip-using-password-yes/3498 "2022-01-18T10:31:30Z")

</div>

I’m trying to configure replication without success on a Kubernetes Environment; error from replicating database cluster: 11142737585 2021-11-09 10:17:11.564 ERROR: Thread 99979: SetConnFromMetadataNode: Connection fa…

---

## [Which Tool to use for generating a Schema Diff?](https://www.singlestore.com/forum/t/which-tool-to-use-for-generating-a-schema-diff/2995)

<div class="topic-metadata">

**Author:** [@sdevaiah](https://www.singlestore.com/forum/u/sdevaiah)\
**Replies:** 4\
**Last updated:** [January 6, 2022, 4:30pm UTC](https://www.singlestore.com/forum/t/which-tool-to-use-for-generating-a-schema-diff/2995 "2022-01-06T16:30:03Z")

</div>

Are there any tools recommended to produce a good schema diff between two MemSQL schemas? For example, I have an older version of a memsql schema and a newer version of a memsql schema, and I’d like to have the diff gene…

---

## [User configuration (Host) on Aggregator and Leaves when SingleStore Spark Connector is used](https://www.singlestore.com/forum/t/user-configuration-host-on-aggregator-and-leaves-when-singlestore-spark-connector-is-used/3543)

<div class="topic-metadata">

**Author:** [@torokl](https://www.singlestore.com/forum/u/torokl)\
**Replies:** 1\
**Last updated:** [November 30, 2021, 9:02pm UTC](https://www.singlestore.com/forum/t/user-configuration-host-on-aggregator-and-leaves-when-singlestore-spark-connector-is-used/3543 "2021-11-30T21:02:09Z")

</div>

Hi Experts, I had two successfull singlestore spark connector development: 1.) AWS Glue Jobs 2.) Databricks NB could connect and transfer tables data Now with a new team I cannot ask SS administrators to let my user …

---

## [SingleStore as a SQL Server linked server](https://www.singlestore.com/forum/t/singlestore-as-a-sql-server-linked-server/3318)

<div class="topic-metadata">

**Author:** [@smaxwell](https://www.singlestore.com/forum/u/smaxwell)\
**Replies:** 2\
**Last updated:** [September 20, 2021, 2:45pm UTC](https://www.singlestore.com/forum/t/singlestore-as-a-sql-server-linked-server/3318 "2021-09-20T14:45:07Z")

</div>

I received a request to compare data between a SingleStore database and a SQL Server database. The QA analyst would like to use SQL Server Management Studio (SSMS), connect to the SQL Server, and query SingleStore as a …

---

## [Any tool that can help compare 2 memsql database schemas and create the migration script](https://www.singlestore.com/forum/t/any-tool-that-can-help-compare-2-memsql-database-schemas-and-create-the-migration-script/2509)

<div class="topic-metadata">

**Author:** [@sdevaiah](https://www.singlestore.com/forum/u/sdevaiah)\
**Replies:** 11\
**Last updated:** [July 9, 2021, 9:40pm UTC](https://www.singlestore.com/forum/t/any-tool-that-can-help-compare-2-memsql-database-schemas-and-create-the-migration-script/2509 "2021-07-09T21:40:59Z")

</div>

To compare two oracle schemas and produce a migration script, we could use a tool called dbForge Schema Compare. Do we have a similar tool that can compare two different Memsql database schemas and generate a migration …

---

## [Python SQLAlchemy alembic support](https://www.singlestore.com/forum/t/python-sqlalchemy-alembic-support/2982)

<div class="topic-metadata">

**Author:** [@borko](https://www.singlestore.com/forum/u/borko)\
**Replies:** 4\
**Last updated:** [May 10, 2021, 5:33pm UTC](https://www.singlestore.com/forum/t/python-sqlalchemy-alembic-support/2982 "2021-05-10T17:33:00Z")

</div>

Hi! I’m working on a POC to set up central schema management inside our team. I’d like to use SQLAlchemy and alembic to combine a pipeline where we can leverage the abstractions provided to generate the migration/revis…

---

## [NodeJS / PHP problems when calling STORED PROCEDURES](https://www.singlestore.com/forum/t/nodejs-php-problems-when-calling-stored-procedures/2705)

<div class="topic-metadata">

**Author:** [@vkruoso](https://www.singlestore.com/forum/u/vkruoso)\
**Replies:** 15\
**Last updated:** [June 23, 2021, 6:32pm UTC](https://www.singlestore.com/forum/t/nodejs-php-problems-when-calling-stored-procedures/2705 "2021-06-23T18:32:06Z")

</div>

Hi! I’m having issues with STORED PROCEDURES when calling using NodeJS or PHP. My procedure should return or echo e Query result set (table) with the computed result. The procedure itself works in SingleStore Studio, an…

---

## [SingleStore (MemSQL) works for Wordpress?](https://www.singlestore.com/forum/t/singlestore-memsql-works-for-wordpress/2739)

<div class="topic-metadata">

**Author:** [@jhatfield](https://www.singlestore.com/forum/u/jhatfield)\
**Replies:** 2\
**Last updated:** [February 10, 2021, 2:54pm UTC](https://www.singlestore.com/forum/t/singlestore-memsql-works-for-wordpress/2739 "2021-02-10T14:54:10Z")

</div>

Hi Guys, I’ve installed SingleStore using docker (operator and node), all looks good I can login with a regular mysql-client from my Linux server (CentOS7) but when I try to install Wordpress using this DB it d only cre…

---

## [Spark dataframe write to Meemsql](https://www.singlestore.com/forum/t/spark-dataframe-write-to-meemsql/1834)

<div class="topic-metadata">

**Author:** [@puliyathsmitha](https://www.singlestore.com/forum/u/puliyathsmitha)\
**Replies:** 8\
**Last updated:** [April 23, 2020, 5:01pm UTC](https://www.singlestore.com/forum/t/spark-dataframe-write-to-meemsql/1834 "2020-04-23T17:01:20Z")

</div>

Hi, I am using memsql version 2.0.1.I am trying to write a dataframe having values(“app\_name”,“table\_name”,3000,true),I wrote to Meemsql using df.write .option(truncate,false) .mode(SaveMode.Append) .jdbc(url,tablen…

---

## [Schema management tool which can work with memsql](https://www.singlestore.com/forum/t/schema-management-tool-which-can-work-with-memsql/1217)

<div class="topic-metadata">

**Author:** [@psinha](https://www.singlestore.com/forum/u/psinha)\
**Replies:** 1\
**Last updated:** [September 10, 2019, 11:19pm UTC](https://www.singlestore.com/forum/t/schema-management-tool-which-can-work-with-memsql/1217 "2019-09-10T23:19:04Z")

</div>

Is memsql known to work with liquibase? With it being wire compatible with mysql, I hope it works, but would like to know if someone is already managing their schema evolution using liquibase and if there is any constrai…

---

## [jOOQ 3.12 now supporting MemSQL](https://www.singlestore.com/forum/t/jooq-3-12-now-supporting-memsql/1195)

<div class="topic-metadata">

**Author:** [@lukas.eder](https://www.singlestore.com/forum/u/lukas.eder)\
**Replies:** 1\
**Last updated:** [September 3, 2019, 11:35pm UTC](https://www.singlestore.com/forum/t/jooq-3-12-now-supporting-memsql/1195 "2019-09-03T23:35:36Z")

</div>

Hi MemSQL community, This is Lukas from the jOOQ team. You’ve already met my colleague Knut over the past months, who has asked quite a few questions about MemSQL syntax. I hope this is the right forum to announce this…

[Next page](https://www.singlestore.com/forum/c/integrations/23.md?page=1)
