cancel
Showing results for 
Search instead for 
Did you mean: 

Data modelling Tool for SAP Sybase IQ

Former Member
0 Kudos

Hello people out there I am new to SAP IQ ?

  • Is there any data modelling tool for SAP IQ like SAP HANA Studio for HANA ?
  • would you please share me links that will clear my doubts about modelling in SAP IQ?
  • In SAP IQ is it just about loading data and querying it using Interactive SQL?

Hope you guys will help me...

Accepted Solutions (0)

Answers (2)

Answers (2)

eduardo_marques2
Explorer
0 Kudos

Hi,

As mentioned before, SAP PowerDesigner is the modeling tool, not just for IQ but for SAP HANA,

Oracle, SQL-Server and so on.... You can use PD to generate scripts for any RDBMS in the list

of supported products. Including incremental changes. Let's say you have a new version of your model.

You can easily generate a script containing the SQL required to implement just the changes you want.

You can also compare different versions of a model, generate reports, and so on....

About SAP Sybase IQ, after working with it for over 15 years, I can tell for sure that it's much, much

more than just loading data and using DBISQL.  Sybase IQ is a very powerful product when it comes

to large scale analytics. Or Big Data, if you want. I mean, databases with hundreds of terabytes,

structured and non-structured data, thousands of users, and so on....

It should be used in conjunction with your BI tools, not just DBISQL, as an information store. Or in conjunction with HANA, as they can be integrated. For those running petabyte-scale BI solutions,

IQ native compression is a major benefit. Not to mention performance.

As a DBMS, IQ supports ODBC, OLEDB and JDBC. Which means you can use any tool you want,

either SAP or non-SAP.

Regards,
Eduardo.

jong-kil_park
Participant
0 Kudos

Hi,

SAP IQ doesn't incldue a modeling tool like like SAP HANA Studio for HANA.

Instead, SAP Powerdesigner will help you develop the modeling in SAP IQ.

It's a global No.1 modeling tool and you can get the free trial for SAP Powerdesigner from the link below.

http://www.sap.com/pc/tech/database/software/model-driven-architecture/index.html

It supports to develop various model type including CDM(Conceptual Data Model), PDM(Physical Data Model), etc.

From the site above, you will be able to find more detail information about SAP Powerdesigner.

Also, there is also community for SAP powerdesigner like this IQ community.

If you have questions in using it, you can ask your questions there.

http://scn.sap.com/community/powerdesigner

Yes, the Interactive SQL is to execute that kind of client tasks.

Please refer to a link to access a manual for Interactive SQL.

http://help.sap.com/saphelp_iq1610_iqdbisql/helpdata/en/a8/8dd74e84f210159a97e70a9818d9be/frameset.h...

HTH.

Best Regards

Jerry