General question regarding extracting data from a Cache' dB
Hi,
I am brand new to Cache and have been tasked with extracting data from the dB. I see that there are a bunch of tools that can be used to extract via SQL Server statements. DataGrip and DBeaver to name 2. I've gone through some documentation and it doesn't look as if SSMS can connect directly. Is there a preferred extraction tool that anyone can recommend. Does the Cache dB have anything built in where I can access the data while seeing a visual of the tables/schema?
Thanks for any advice,
Hi @John Lisa
You can use IRIS Management Portal. There is a built-in tool to extract information using SQL.
The Path is: System Explorer > SQL
Inside the SQL Explorer, you can change to your preferred Namespace and have access to your tables, as you can see in the image below:
Hope that helps.
Best Regards,
Henrique
Hi Henrique,
Thank you for the speedy reply. Very anxious to give this a run!
Regards!
John
I have tried a small sample extract using SQL code in the 'System Explorer' function on the management portal.
With just a few joins and a small sampling of invoices, I get this message:
.png)
I have to extract large volumes of various data for an integrations project. Are the other tools mentioned better (DBeaver and DataGrip) to handle large files?
Hi @John Lisa
If you need to extract a large amount of data, the other options DBeaver and Datagrip, are better choices.
I usually use DBeaver to deal with situations like this.
Because using JDBC, you don't have the Gateway Time-out problem.
HTH
That's a general problem of a web interface like this.
You start a query but it isn't finished before your fall into a browser timeout.
An easy workaround:
Start a terminal session (terminals don't know about timeout)
and from prompt run SQl.Shell
or for a multi-line statement just start with an empty line and run with GO
It will wait forever until completed
Will check it out. T.Y.
DataGrip works.
DBearver works. Here are settings for Cahé on locathost with superport=1972 and namespace SAMPLES.
Martin
Thanks. Looks like I'm gonna try to have my infrastructure team install this.