Product - Protocol
SQL
What is SQL?
Structured query language (SQL) is a programming language typically used for storing and processing information in a relational database. You can use SQL statements to store, update, remove, search, and retrieve information from the database. You can also use SQL to maintain and optimize database performance.
Babelway and SQL
Babelway allows you to retrieve or insert data into Oracle, PostgreSQL, or any other database on request.
Getting started with Babelway
1. Fill in server address and credentials
2. Fill in database, table name
3. You're ready to go!
To retrieve data from a database, the following parameters will be defined:
- Host: The host of the database you wish to connect to
- Username and password
- Database system: Oracle or PostgreSQL (others available upon request)
- Database Name:
- SSL for an optional secured connection to the database.
- Table Name: Table containing the data to retrieve
- Column name(s) can be added if data needs to be retrieved from a limited set of columns (blank = all)
After data is retrieved, the row can be either deleted or updated.
To insert data from a Database, the following parameters will be defined:
- Host: The host of the database you wish to connect to
- User and password
- Database system: Oracle or PostgreSQL (Others on request)
- Database Name
- SSL for an optional secured connection to the database.
Why Babelway?
Set up with ease
Deploy your connection in seconds, making it ready for testing immediately.
Transform any format
Use simple drag & drop tools to map your message to any other format for easy import/export in or from your database.
Connect to anyone
Connect your Babelway environment using any EDI or non-EDI communication protocols.
Support
Babelway is not only a great self-service platform but also a team of pros ready to help you succeed.
- Access our support helpdesk anytime and ask your questions. You will be answered as soon as max 60 minutes
- Spot the ‘reuse and save time’ zone on the right of the screen? Import messages and maps from our catalog
- Access online training material through Babelway Academy
What have our clients said about AS2 in Babelway?
“Babelway helps us innovate in B2B collaboration.”
Read case study >
“Their product and their experts ensure that we’ll have an innovative B2B integration solution, not just right now, but in the years to come.”
g2.com
GetApp
Try our free 30 day trial to see how easy it is work with AS2
Learn about the other protocols
Amazon MWS
Amazon Marketplace Web Service, an API that gives sellers programmatic access to Amazon Seller Central data such as orders, inventory, and reports.
Chorus Pro
The French government's official platform for receiving electronic invoices from suppliers to public sector entities.
Dropbox
A cloud file storage and sharing service that can be used as a pickup and drop-off point for exchanging documents with trading partners.
REST API Client
A generic connection method for sending and receiving data over HTTP with any system that exposes a REST API.
RosettaNet
A set of standardized XML-based business process and messaging protocols, used mainly in the high-tech and electronics supply chain.
SAP
A connection to SAP ERP systems, typically via IDocs, BAPIs, or RFC calls, for exchanging business documents and data directly with SAP.
SQL
A standardized language for querying and managing data in relational databases, used here to connect directly to a database rather than exchange files.