Trust ID PBCEX logo 300x102

What does native connections mean for the user?

12 years 6 months ago
Audra
Moderator
Moderator
Posts: 51
More
Topic Author
What does native connections mean for the user? #221
Hi There.

I know that we support native connections to databases such as MySQL, Oracle, DB2, PostgreSQL.

However, can you tell me the benefit of native connections? Does it increase the speed of data communication?

Thanks!

Audra
cardexchangesolutions.com
12 years 6 months ago
Rutger Koperdraad
Platinum Boarder
Platinum Boarder
Posts: 1566
More
What does native connections mean for the user? #222
"Native connection" means that CardExchange communicates directly with the database and that there is no other connection software in between (except of course the software that enables communication over the network in general). The most common software that could be in between is ODBC or OleDb. The latter is the successor of ODBC, but ODBC is still used widely and better known than OleDb.

The good thing about ODBC is, that if a database suports ODBC, CardExchange can communicate with that database via ODBC, without any effort from our side. For Native connections, on the other hand, CardExchange needs explicitely built-in support for that specific database. Since there is a vast amount of databases on the market, it is impossible to support all of the natively.

The advantages of native connections are:
  • Faster and more stable connections
  • No need to configure the ODBC connection in teh ODBC manager and therefore easier to set up

Rutger Koperdraad
Senior Software Engineer

"A reasonable man adapts himself to the world. The unreasonable man persists in trying to adapt the world to himself. All progress, therefore, depends on the unreasonable man." (Bernard Shaw)
12 years 6 months ago
Audra
Moderator
Moderator
Posts: 51
More
Topic Author
What does native connections mean for the user? #223
Thanks so much! That really helps!

Audra
cardexchangesolutions.com