SAP SQL Anywhere
This is the implementation of the SAP SQL Anywhere data handler for MindsDB.
SAP SQL Anywhere is an embedded database for application software that enables secure and reliable data management for servers where no DBA is available and synchronization for tens of thousands of mobile devices, Internet of Things (IoT) systems, and remote environments.
Prerequisites
Before proceeding, ensure the following prerequisites are met:
- Install MindsDB locally via Docker or use MindsDB Cloud.
- To connect SAP SQL Anywhere to MindsDB, install the required dependencies following this instruction.
- Install or ensure access to SAP SQL Anywhere.
Implementation
This handler is implemented using sqlanydb
, the Python driver for SAP SQL Anywhere.
The required arguments to establish a connection are as follows:
host
is the host name or IP address of the SAP SQL Anywhere instance.port
is the port number of the SAP SQL Anywhere instance.user
specifies the user name.password
specifies the password for the user.database
sets the current database.server
sets the current server.
Usage
You can use the below SQL statements to create a table in SAP SQL Anywhere called TEST
.
CREATE TABLE TEST
(
ID INTEGER NOT NULL,
NAME NVARCHAR(1),
DESCRIPTION NVARCHAR(1)
);
CREATE UNIQUE INDEX TEST_ID_INDEX
ON TEST (ID);
ALTER TABLE TEST
ADD CONSTRAINT TEST_PK
PRIMARY KEY (ID);
INSERT INTO TEST
VALUES (1, 'h', 'w');
In order to make use of this handler and connect to the SAP SQL Anywhere database in MindsDB, the following syntax can be used:
CREATE DATABASE sap_sqlany_trial
WITH
ENGINE = 'sqlany',
PARAMETERS = {
"user": "DBADMIN",
"password": "password",
"host": "localhost",
"port": "55505",
"server": "TestMe",
"database": "MINDSDB"
};
You can use this established connection to query your table as follows:
SELECT *
FROM sap_sqlany_trial.test;
On execution, we get:
ID | NAME | DESCRIPTION |
---|---|---|
1 | h | w |