Selecting Database ( external )

[manhunbas]

I just found this "upgraded" version of wfqbe.
I used the TER Version for quite some time but since i have to upgrade Typo3 i have to also upgrade this Extension.
I am not quit sure how to select the external Database.....

Any help is welcomme.
Manfred

[woepwoep]

This version of WFQBE is not the same product as the original version (the TER version).
The original authors no longer respond to requests for upgrade. TYPO3 v7 was the last time the original product was upgraded.

This version is also called WFQBE and it is a total rewrite from scratch.
So there is also no longer a table for database connections, because database connections are now found in a file in typo3conf directory. Also there is no longer a query table, because the query is stored in the flexform itself.

In syntax, if the tables are in the TYPO3 database, you can write a query like 'select * from tableA'.
If the tables are in another database but available for the admin user, you can write 'select * from databaseB.tableA'.

Hope this helps.
Best regards, Ron.

[manhunbas]

Thanks very much for your Answer and your work.
Will try this.
Shalom Manfred

[manhunbas]

Hi Ron
Did try to get it working with a external DB, internal Tables works fine.
I did add my external DB in the LocalConfiguration.php like here:
https://docs.typo3.org/m/typo3/reference-coreapi/master/en-us/ApiOverview/Database/Configuration/Index.html

Would be super nice to now how to access a external DB.
Maybe it would be also possible to ad your great work to the typo3 repository?
Is there also a version for Typo3 10 planed?
I understand that also updating the ext can be quite some work, maybe a lik to a PayPal donation or so is interesting?

Greetings
Manfred

[manhunbas]

Hi Ron
Just wanna ask, will there also be a version for Typo3 10?

Just found a way to work with other Databases.
I create a view from one DB to another.
See here:
https://stackoverflow.com/questions/10694601/creating-view-across-different-databases

Greetings
Manfred

[woepwoep]

yes the github version works with T3v10 thanks for the tip. it is also possible to link a database on machine M1 to a linked database name on machine M2. it is somewhere in the mysql documentation. ---- Tel: +31 629 584 582 http://about.me/woepwoep Op do 1 okt. 2020 om 11:31 schreef manhunbas <[email protected]>:

…

Hi Ron Just wanna ask, will there also be a version for Typo3 10? Just found a way to work with other Databases. I create a view from one DB to another. See here: https://stackoverflow.com/questions/10694601/creating-view-across-different-databases Greetings Manfred — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#3 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AA5ARHA5VCRLHMACLDWV33DSIRD6XANCNFSM4QTEEEKQ> .

[woepwoep]

hi Manfred, i just applied the v10 updates. Feel free to comment. Thanks, Ron.

[manhunbas]

Hi Ron
Works fine in Typo3 10. ;-)