1010data vs SAP Adaptive Server Enterprise (ASE), legacy

Likelihood to Recommend

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.

Read full review

Marc Gilbert

Structured Finance Associate Analyst

Fitch RatingsFinancial Services, 1001-5000 employees

View all 2 answers on this topic

High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.

Read full review

Gene Baker

Vice President, Chief Architect, Development Manager and Software Engineer

WySTAR Global Retirement Solutions, a Wells Fargo CompanyFinancial Services, 10,001+ employees

View all 2 answers on this topic

Pros

To "pool" their data for market analysis
Very large data analysis
Performance and scalability

Read full review

Henry PAN

NAS SME, ESE

Providence Health & ServicesHospital & Health Care, 10,001+ employees

View all 2 answers on this topic

Easy to setup and maintain
Reliable, rarely has major hiccups requiring reboots or crashes
Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows

Read full review

Zhann Goloborodko

Senior Programmer/Analyst

Investment Company InstituteThink Tanks, 51-200 employees

View all 2 answers on this topic

Cons

The ten.do interface could use more detailed documentation

Read full review

Marc Gilbert

Structured Finance Associate Analyst

Fitch RatingsFinancial Services, 1001-5000 employees

View all 2 answers on this topic

Full database encryption - need to utilize external keys vs internal - for better separation of duties.
History Tables.

Read full review

Gene Baker

Vice President, Chief Architect, Development Manager and Software Engineer

WySTAR Global Retirement Solutions, a Wells Fargo CompanyFinancial Services, 10,001+ employees

View all 2 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Starting Price

—

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Starting Price

—

Likelihood to Renew

No score

No answers yet

No answers on this topic

SAP Adaptive Server Enterprise (ASE), legacy 10.0

Based on 1 answer

Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.

Read full review

Gene Baker

Vice President, Chief Architect, Development Manager and Software Engineer

WySTAR Global Retirement Solutions, a Wells Fargo CompanyFinancial Services, 10,001+ employees

View all 1 answers on this topic

Usability

1010data 8.0

Based on 1 answer

That's votes by our team.

Read full review

Henry PAN

NAS SME, ESE

Providence Health & ServicesHospital & Health Care, 10,001+ employees

View all 1 answers on this topic

SAP Adaptive Server Enterprise (ASE), legacy 9.0

Based on 1 answer

It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.

Read full review

Gene Baker

Vice President, Chief Architect, Development Manager and Software Engineer

WySTAR Global Retirement Solutions, a Wells Fargo CompanyFinancial Services, 10,001+ employees

View all 1 answers on this topic

Support Rating

No score

No answers yet

No answers on this topic

SAP Adaptive Server Enterprise (ASE), legacy 9.7

Based on 4 answers

Incredibly responsive, saving us countless hours in troubleshooting.

Read full review

Zhann Goloborodko

Senior Programmer/Analyst

Investment Company InstituteThink Tanks, 51-200 employees

View all 4 answers on this topic

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.

Read full review

Marc Gilbert

Structured Finance Associate Analyst

Fitch RatingsFinancial Services, 1001-5000 employees

View all 2 answers on this topic

Much less effort than Oracle. Much better customer support than Oracle.Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server.Different ballpark from IQ. Same customer service.

Read full review

Zhann Goloborodko

Senior Programmer/Analyst

Investment Company InstituteThink Tanks, 51-200 employees

View all 2 answers on this topic