Is it possible to import a Cube from SQLServer (format .abf) in Cache?

Question

Question

Razvan Prepelita · Jul 28, 2017

#Object Data Model #SQL #InterSystems IRIS BI (DeepSee)

Is it possible to import a Cube from SQLServer (format .abf) in a Cache?

I have an .abf file and I want to open it in Cache. Is it possible?

Thanks

Discussion (4)0

Log in or sign up to continue

Dmitry Maslennikov · Aug 1, 2017

As far as I know .abf file format, it is just backup for MSSQL Databases. So, It is not possible and will not possible in any way. And all this conversion will not be such easy. And you should understand that Cubes, that not about data before you should migrate all the data, and create new cubes in Caché with knowledge about, how it was in MS SQL.

0 0

score 0 · Answer 1 · 2017-07-28T10:18:22-04:00

Hi, Razvan!

I doubt that it is possible at the moment.

Caché has DeepSee embedded technology to build BI solutions.

What exactly do you want to do? Move BI Solution from SQLServer to Caché?

score 0 · Answer 2 · 2017-07-28T22:29:31-04:00

Razvan Prepelita · Jul 28, 2017

Yes.

I have a cube in SQL Server and I want to migrate to Cache.

Should I export first to csv? Or?

Thanks

0 0

score 0 · Answer 3 · 2017-07-29T03:42:55-04:00

I think in your case of migrating MS SQL cube to DeepSee cube means building the whole BI solution in DeepSee from the scratch.

I mean:

1. ETL the data from MS SQL into Caché fact tables (Caché classes).

2. Build DeepSee cube(or cubes) against the fact tables.

3. Introduce pivot tables with MDX-queries against DeepSee cube (cubes).

4. Make dashboards to provide the UI for this pivot tables.

Profit!