Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does PowerTools SQL access my BusinessVision database?

April 26, 2017businessvision database powertools sql

0

Posted

How does PowerTools SQL access my BusinessVision database?

1 Answer

0

Posted

PowerTools connects to your BusinessVision database utilizing the Pervasive.SQL relational interface or otherwise known as ODBC (Open Database Connectivity). ODBC is a API (Application Program Interface) standard used to communicate with a Relational Databases such as Microsoft SQL Server, Informix, IBM, Oracle or Pervasive.SQL to name a few. SQL (Structured Query Language) is a high level database language used to talk to a Relational Database. MK PowerTools SQL leverages this high-level language whereas BusinessVision uses a lower-level Btrieve API. There are 2 key reasons why using the SQL interface is the best.