Re: [Qgis-user] Oracle DB connection in QGIS

2023-12-19 Thread Fabio Fumi via QGIS-User 
Hi Stephan, all,

I had posted a question about DB connections, a few weeks ago:

https://lists.osgeo.org/pipermail/qgis-user/2023-November/053641.html

You can help, maybe...
Is there any chance to get a connection with an Oracle Proxy user, in QGis?
I'm afraid there's not...

thank you
Fabio



Il giorno mer 20 dic 2023 alle ore 08:08 Huesmann, Michaela via QGIS-User <
qgis-user@lists.osgeo.org> ha scritto:

> Hi Stefan,
>
>
>
> thank you for that hint. It helps a lot!
>
>
>
> Best regards,
>
> Michaela
>
>
>
> *Von:* QGIS-User  *Im Auftrag von *Stefan
> Giese (WhereGroup) via QGIS-User
> *Gesendet:* Freitag, 15. Dezember 2023 08:44
> *An:* qgis-user@lists.osgeo.org
> *Betreff:* Re: [Qgis-user] Oracle DB connection in QGIS
>
>
>
> Hi Michaela,
>
> did you check theese options?
>
>- "Use estimated table metadata"
>- "Only look for user tables"
>
> best regards
>
> Stefan
>
> Stefan Giese
>
> Projektleiter/Consultant
>
> **
>
> Where2B Konferenz 2023
>
> 14. Dezember 2023 in Bonn und Online
>
> https://where2b-conference.com/
>
> **
>
> WhereGroup GmbH
>
> Schwimmbadstr. 2
>
> 79100 Freiburg
>
> Germany
>
>
>
> Tel.: +49 (0)761 / 519 102 - 61
>
> Fax: +49 (0)761 / 519 102 - 11
>
>
>
> stefan.gi...@wheregroup.com
>
> www.wheregroup.com
>
> Geschäftsführer:
>
> Olaf Knopp, Peter Stamm
>
> Amtsgericht Bonn, HRB 9885
>
> Am 15.12.2023 um 08:28 schrieb Huesmann, Michaela via QGIS-User:
>
> Hello QGIS Users,
>
>
>
> I need to access an Oracle Database in QGIS. The scheme I need to connect
> to has plenty of tables and Views and it seems that all data is loaded in
> the background even before I was able to select the few tables I will
> really need. This lakes a lot of time.
>
> Is this a normal behaviour or can I ajust something in Database options?
> Thanks for your help!
>
>
>
> Best regards,
>
> Michaela
>
>
>
>
>
>
>
> [image: Kreisstadt Steinfurt] <http://www.steinfurt.de>
>
>  - 48565 Steinfurt
> www.steinfurt.de
>
>
>
> Mit freundlichen Grüßen
> im Auftrag
> *Michaela Huesmann*
> *IT*
> Fachdienst Tiefbau
>
> Tel.: +49 2552 925 219
> Fax:
> E-Mail: michaela.huesm...@stadt-steinfurt.de
>
>
> Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.
>
>
>
> ___
>
> QGIS-User mailing list
>
> QGIS-User@lists.osgeo.org
>
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-us
>
> ___
> QGIS-User mailing list
> QGIS-User@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Oracle DB connection in QGIS

2023-12-19 Thread Huesmann, Michaela via QGIS-User 
Hi Stefan,

thank you for that hint. It helps a lot!

Best regards,
Michaela

Von: QGIS-User  Im Auftrag von Stefan Giese 
(WhereGroup) via QGIS-User
Gesendet: Freitag, 15. Dezember 2023 08:44
An: qgis-user@lists.osgeo.org
Betreff: Re: [Qgis-user] Oracle DB connection in QGIS


Hi Michaela,

did you check theese options?

  *   "Use estimated table metadata"
  *   "Only look for user tables"

[cid:image001.png@01DA331B.AA202D60]
best regards
Stefan

Stefan Giese

Projektleiter/Consultant

**

Where2B Konferenz 2023

14. Dezember 2023 in Bonn und Online

https://where2b-conference.com/

**

WhereGroup GmbH

Schwimmbadstr. 2

79100 Freiburg

Germany



Tel.: +49 (0)761 / 519 102 - 61

Fax: +49 (0)761 / 519 102 - 11



stefan.gi...@wheregroup.com<mailto:stefan.gi...@wheregroup.com>

www.wheregroup.com<http://www.wheregroup.com>

Geschäftsführer:

Olaf Knopp, Peter Stamm

Amtsgericht Bonn, HRB 9885
Am 15.12.2023 um 08:28 schrieb Huesmann, Michaela via QGIS-User:
Hello QGIS Users,

I need to access an Oracle Database in QGIS. The scheme I need to connect to 
has plenty of tables and Views and it seems that all data is loaded in the 
background even before I was able to select the few tables I will really need. 
This lakes a lot of time.
Is this a normal behaviour or can I ajust something in Database options? Thanks 
for your help!

Best regards,
Michaela



[Kreisstadt Steinfurt]<http://www.steinfurt.de>

 - 48565 Steinfurt
www.steinfurt.de<http://www.steinfurt.de>



Mit freundlichen Grüßen
im Auftrag
Michaela Huesmann
IT
Fachdienst Tiefbau

Tel.: +49 2552 925 219
Fax:
E-Mail: 
michaela.huesm...@stadt-steinfurt.de<mailto:michaela.huesm...@stadt-steinfurt.de>


Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.




___

QGIS-User mailing list

QGIS-User@lists.osgeo.org<mailto:QGIS-User@lists.osgeo.org>

List info: https://lists.osgeo.org/mailman/listinfo/qgis-user

Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-us
___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Oracle DB connection in QGIS

2023-12-14 Thread Stefan Giese (WhereGroup) via QGIS-User 

Hi Michaela,

did you check theese options?

 * "Use estimated table metadata"
 * "Only look for user tables"

best regards
Stefan

Stefan Giese
Projektleiter/Consultant
**
Where2B Konferenz 2023
14. Dezember 2023 in Bonn und Online
https://where2b-conference.com/
**
WhereGroup GmbH
Schwimmbadstr. 2
79100 Freiburg
Germany

Tel.: +49 (0)761 / 519 102 - 61
Fax: +49 (0)761 / 519 102 - 11

stefan.gi...@wheregroup.com
www.wheregroup.com
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885

Am 15.12.2023 um 08:28 schrieb Huesmann, Michaela via QGIS-User:


Hello QGIS Users,

I need to access an Oracle Database in QGIS. The scheme I need to 
connect to has plenty of tables and Views and it seems that all data 
is loaded in the background even before I was able to select the few 
tables I will really need. This lakes a lot of time.


Is this a normal behaviour or can I ajust something in Database 
options? Thanks for your help!


Best regards,

Michaela


Kreisstadt Steinfurt 

 - 48565 Steinfurt
www.steinfurt.de 

Mit freundlichen Grüßen
im Auftrag
MichaelaHuesmann
IT
Fachdienst Tiefbau

Tel.: +49 2552 925 219
Fax:
E-Mail: michaela.huesm...@stadt-steinfurt.de 




Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.


___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-us___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Oracle DB connection in QGIS

2023-12-14 Thread Huesmann, Michaela via QGIS-User 
Hello QGIS Users,

I need to access an Oracle Database in QGIS. The scheme I need to connect to 
has plenty of tables and Views and it seems that all data is loaded in the 
background even before I was able to select the few tables I will really need. 
This lakes a lot of time.
Is this a normal behaviour or can I ajust something in Database options? Thanks 
for your help!

Best regards,
Michaela



[Kreisstadt Steinfurt]

 - 48565 Steinfurt
www.steinfurt.de

Mit freundlichen Grüßen
im Auftrag
Michaela Huesmann
IT
Fachdienst Tiefbau

Tel.: +49 2552 925 219
Fax:
E-Mail: 
michaela.huesm...@stadt-steinfurt.de

Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.

___
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user