ETL tools in the Cache database

Question

Question

Sheng Li · Mar 6, 2021

#Caché

Is there any ETL tools for the data process in the Cache database?

Discussion (10)1

Log in or sign up to continue

Robert Cemper · Mar 10, 2021

You are correct. I can confirm it.
I was part of the process when DeepSee V1 was prepared.

0 0

Kok Sheng How · Mar 10, 2021

Speedminer's objective is especially to ETL external databases into Cache to create a Data Warehouse (although it works well with data already in Cache database), therefore ETL is an important module for us. If you just need to copy data from external database to Cache once, Cache Management Portal already has the feature to do so, Speedminer ETL will be more for continue update of data loading including incremental update. Speedminer also support data transformation, data profiling and other features.

0 0

score 0 · Answer 1 · 2021-03-10T00:25:10-05:00

Speedminer Business Intelligence provides ETL tool for Cache Database http://www.speedminer.com/data-ingestion/

score 0 · Answer 2 · 2021-03-10T07:10:31-05:00

Am I correct that there's some kind of relationship between the Speedminer tools and Intersystems DeepSee Visual Reporting?

score 0 · Answer 3 · 2021-03-10T12:25:09-05:00

Interesting solution! Do you want to publish the ETL Speedminer on Open Exchange ? To let everyone know and find it easier?

score 0 · Answer 4 · 2021-03-10T13:12:16-05:00

Sure, but I am not familiar with Open Exchange, not sure how to go about to publish it. Speedminer is our product mainly sold in Malaysia market currently.

score 0 · Answer 5 · 2021-03-10T13:45:25-05:00

Here is the instruction on how to submit the solution. And here is how you can list the company if you want to present Speedminer on behalf of the company. You can use DC account to sign in.

score 0 · Answer 6 · 2021-03-11T01:52:35-05:00

Thanks, I will setup company information soon, as for submission of solution, we need time to learn how to create Docker then work on preparing the solution.

score 0 · Answer 7 · 2021-03-16T11:31:39-04:00

Hi Kok Sheng How!

It's not mandatory to create docker for the app.

You can submit it as a landing page where app could be downloaded. E.g. check Dbeaver or George James

score 0 · Answer 8 · 2021-03-15T10:58:39-04:00

Interoperability (ex. Ensemble) can be used to both import data into InterSystems Data Platforms and push it to external systems.