I confess I use SQL Server more these days than Oracle, but the only possible option I can find that would let you see multiple databases seems to be if you're using something like Enterprise Manager Cloud Control - https://www.mydbaworld.com/extract-databases-server-os-version-of-oem-repository/]">Extract the list of all databases with server and OS version of Oracle Enterprise Manager Cloud Control repository - My DBA World
I'm a new Dev.
I wanted to learn more about how google classrooms database works, Like when a student enters a Code it will then proceed to the classroom and displays all the data on that classroom? I want to learn, how does that work. Would love to hear some suggestions on where to learn more about how it works.
Yes, I understand. One of the most popular arguments for having Data Warehouse is that it should enable the user to access data/information faster.
I have been thinking about these points (Benefits of having a data Warehouse) for a long time now. At the moment we do not have a very large business or production database. The largest of tables transaction log) consist of around 8 million records with 40 fields. So, I don't think speed of access is our problem however, I do agree with some of the other benefits like:
2. Enhances Conformity And Quality Of Data
3. Boosts Efficiency "to have to gather data from multiple sources"
In our case we have many different types of databases (data islands) most of them SQL Server... So, I think that the DW would solve the challenge of bringing everything together in order to give the user a better view of how the business when all data is brought together into one view ("to have to gather data from multiple sources").
Again, thank you for the reply and the information ....
Boosts Efficiency "to have to gather data from multiple sources"
It also lowers frustration!
After I had posted my reply I had to spend (waste?) quite some time combining data from 3 different sources (oh - and we do have a DW here, it's just not comprehensive. So we've introduced a second one on a different platform - you couldn't make this up really)
It's "doable", especially with modern connectors and tools, but a real PITA - I seem to waste more time sourcing data to then be merged, than I do actually doing the analysis to gain insight. Like I said - frustrating.
Perhaps then that is your most compelling argument ... A DW makes it easier and quicker to bring real insight to the business, turn data into information, to drive down costs and raise profitability.
(I'm starting to sound like an advert so I will stop there )
I have Delphi 11 Alexandria Professional edition.
This edition includes Firedac but I can only access local databases (hosted on the same machine that the application executable).
Can I access to MySQL or SQL databases both local or remote using UNIDAC with my Delphi edition?
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
Ive tried the INNER, LEFT, RIGHT join but it doesnt seem as if my tables are connecting. I have tables with different names and none match. I also have a main table(login/register) and want the rest to connect to that. How do I go about doing this?