topic Re: SQL Treibereinbindung in qlik replicate in Qlik Replicate

SQL Treibereinbindung in qlik replicate

StefanSchmidt — Tue, 15 Aug 2023 08:27:58 GMT

Hallo,

Wo finde ich bei Replicate den Verweis, auf den sqlite-Treiber, den Repicate benutzt ? Kann dazu leider nichts finden.

Re: SQL Treibereinbindung in qlik replicate

john_wang — Tue, 15 Aug 2023 09:53:48 GMT

Hello @StefanSchmidt ,

Welcome to Qlik Community forum and thanks for reaching out here.

I'm not very sure if I understood the question correctly. Regarding SQLite:

1- Replicate utilizes SQLite as repository storage.

2- Replicate does not provide prebuild endpoint for SQLite yet. All supported source and target endpoints can be found in Supported Platforms and Endpoints.

Hope this helps.

Regards,

John.

Re: SQL Treibereinbindung in qlik replicate

Heinvandenheuvel — Tue, 15 Aug 2023 13:22:34 GMT

Instead of posting a question in any language other than English you may want to use google translate or similar to reach a bigger audience. You readers can do this, but then all would have to do it. So why please save us the trouble and take the opportunity to see if the translation looks reasonable. Here it does...

With Replicate, where can I find the reference to the sqlite driver that Repicate uses? Unfortunately I can't find anything about it.

As you do this you may notice that a short question like this is a bit open. It would help to indicate WHY you think you need to know this.

Anyway... One tool is to go to a table, any table in designer. Select TRANSFORM and pick a columns, any column, now select "Fx" for expression. Enter "sqlite_version()", <parse> and <test>. I get "3.36.0". Does that answer your question?

In the Replicate BIN directory you'll find "System.Data.SQLite.dll" - that's likely the driver code used.

Hein.