Question
John Lisa · Jul 16, 2020

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,

0
0 672
Discussion (9)1
Log in or sign up to continue

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:

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.

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.