General question regarding extracting data from a Cache' dB

Question

Question

John Lisa · Jul 16, 2020

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,

Discussion (9)1

Log in or sign up to continue

Henrique Dias · Jul 16, 2020

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

1 0

score 1 · Answer 1 · 2020-07-16T18:19:06-04:00

John Lisa · Jul 16, 2020

Hi Henrique,

Thank you for the speedy reply. Very anxious to give this a run!

Regards!

John

1 0

score 0 · Answer 2 · 2020-08-07T12:14:53-04:00

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?

score 0 · Answer 3 · 2020-08-07T14:11:39-04:00

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

score 3 · Answer 4 · 2020-08-07T15:45:00-04:00

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

score 0 · Answer 5 · 2020-08-09T19:52:11-04:00

John Lisa · Aug 9, 2020

Will check it out. T.Y.

0 0

score 1 · Answer 6 · 2020-07-17T03:42:48-04:00

Eduard Lebedyuk · Jul 17, 2020

DataGrip works.

1 0

score 1 · Answer 7 · 2020-07-17T09:34:50-04:00

Martin Fukátko · Jul 17, 2020

DBearver works. Here are settings for Cahé on locathost with superport=1972 and namespace SAMPLES.

Martin

1 1

score 0 · Answer 8 · 2020-08-08T16:25:37-04:00

John Lisa · Aug 8, 2020

Thanks. Looks like I'm gonna try to have my infrastructure team install this.

0 0