Bizdata Universal API for Database
Bizdata Universal APIs are a comprehensive collection of flexible and adaptable application programming interfaces (APIs) designed to facilitate efficient connectivity and seamless access to a wide range of databases. These APIs serve as a unified gateway, enabling users to establish connections with various platforms such as Oracle Database, Microsoft SQL Server, MySql/MariaDB, Snowflake, Amazon Redshift, Amazon Aurora Database, and Postgres SQL.
POST
This endpoint is used to retrieve an authentication token from the API. The token serves as an authorization mechanism to access and interact with the various API endpoints.
POST
This endpoint allows access to the Universal API of the BizData360 platform for interacting with an Oracle Database.
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}POST
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Microsoft SQL Server database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}POST
This endpoint allows access to the Universal API of the BizData360 platform for interacting with MySQL/Maria database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}POST
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Snowflake database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}POST
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Amazon Redshift database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}POST
This endpoint allows access to the Universal API of the BizData360 platform for interacting with Amazon Aurora database (MySQL/Maria)
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}POST
This endpoint allows access to the Universal API of the BizData360 platform for interacting with PostgreSQL database
{
"username":"{{username}}",
"password":"{{password}}",
"query":"{{SELECT/INSERT QUERY}}",
"schema_name":"{{schema_name}}",
"hostname":"{{host_name}}",
"portnumber":{{port_number}}
}Note :
To try out the provided API endpoints on our eZintegrations app, please follow the steps below:
- Visit our website: www.bizdata360.com
- Click on the "Try it here" to create a new user account.
- Fill in the required information to complete the signup process.
- Once registered, log in to your account using your credentials.
- Navigate to the API Marketplace section on our website.
- In the API Marketplace, you will find the Bizdata Universal API.
- Take a look at the available endpoints and you can try it out.
For Base URL, Username and Password or Pem-key and other queries related to Bizdata UniversalSFTP API, please reach out to our support team at: