Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I have a SQL Anywhere 12.0.1 database, am interfacing with a number of systems by letting them log on via ODBC into my database and executing stored procedures i wrote. This is not very secure as my DB has financial information so am looking for an API to buy or freeware, where can i get one preferably one that is ISO 8583 complient.

asked 21 Sep '11, 04:09

Takudzwa's gravatar image

Takudzwa
818813
accept rate: 0%

edited 21 Sep '11, 06:09

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822


( From: http://en.wikipedia.org/wiki/ISO_8583 )

Although ISO 8583 defines a common standard, it is not typically used directly by systems or networks. It defines many standard fields (data elements) which remain the same in all systems or networks, and leaves a few additional fields for passing network specific details. These fields are used by each network to adapt the standard for its own use with custom fields and custom usages

Typically, industry-specific security standards are more highly emphasized for software such as PCI for financial data, HIPAA for medical data, or FIPS for government applications. You should investigate the specific industry standards for the software market you're pursuing.


SQL Anywhere supports many different APIs for many different languages, including ODBC, JDBC, .NET, Ruby, PHP, Perl, Python, Embedded SQL, and others. The "way" you use the various APIs and the database in your application forms the basis for a potential ISO/standards certification.

SQL Anywhere also supports other various security and auditing features to help secure your data.

permanent link

answered 21 Sep '11, 13:43

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

edited 21 Sep '11, 14:31

Isn't this just a matter of what a combination of users and rights you use in your database? SQL Anywhere has a huge set of rights you can apply to database objects see permissions overview

permanent link

answered 21 Sep '11, 05:12

Martin's gravatar image

Martin
9.0k130169257
accept rate: 14%

edited 21 Sep '11, 05:12

In addition to Martin's answer:

There also ways to encrpyt data, e.g.

permanent link

answered 21 Sep '11, 06:07

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×48

question asked: 21 Sep '11, 04:09

question was seen: 2,436 times

last updated: 21 Sep '11, 14:31