Natural Language to SQL
Bad business decisions result in financial loss. The worst business decisions lose companies billions in revenue.
Why employees are doing bad business decisions every day?
Each particular case has its own reasons, but the most common reason is lack of information before doing the business decision.
How employees should get information for proper business decisions? Make a request to the IT department? Open and update excel report? Run SQL query to get specific information?
What if, instead of spamming IT department or running complex SQL scripts everyone could simply ask your database a question using only Natural Language? What is the TOP product in my sales to my customer last month? What is the average weighted margin of my customer this year?
That would allow anyone to easily make data-driven decisions, increasing productivity and driving businesses forward faster.
We are now ready to provide you an ML learning tool, that you are able to customize by yourself, even if you are not the technical person.
Below you can find 8 simple steps to proceed with Natural Language to SQL customization tool by yourself with almost no integration cost:
After testing our demo version (created only for demonstration purpose) with import-export open data USA trade balance statistics, let’s get started with NLSQL customization as per your database.
- Please login and click on your login name
and browse to the settings page from drop-down menu
2. On the Settings page you can find your unique ID code:
Please copy this code and send it to NLSQL chatbot in order system identify you as an authenticated user. NLSQL chatbot available on Skype, Telegram, Facebook messenger, Slack or website.
3. Click on database settings:
Below you can find database settings required for NLSQL integration
Database host is the database location via the internet
The database name is the current database name. You should create a new Read Only user for NLSQL and provide user access to the tables you need.
The database password is abovementioned Read Only user password
Technical contact email for tech questions in case of any questions
Technical contact phone for tech questions in case of any questions
SQL Script Sample is an example of a commonly used SQL select query (including JOIN clause) you want to include into NLSQL cognitive technology
4. In order to add synonyms and use it in your communication with NLSQL, click on Synonyms from the drop-down menu
after feel free to include as many synonyms as you need by typing database value and synonyms you would like to use
also, you can delete synonyms by clicking red cross in case of mistake
5. In order to add kwargs (arguments, which NLSQL can use for querying your dataset) click on Kwargs from the dropdown menu:
Below you can add database table name and column name you would like NLSQL to use
6. In order to add and manage your company users, click on Company from the drop-down menu:
Here you can add or delete your company users, provide them information access rules, etc.
7. In order to add subscription plan please click on Subscription from the dropdown menu
Once you are ready click on the +add subscription button
and choose your subscription plan
8. Once all settings are completed and subscription is added,
the system needs 3–4 days to train NLSQL and get back to you for the first testing linked to your messenger application
NLSQL already works with MySQL, MS SQL, Postgres, Cassandra, Mongo, NoSQL databases.
Also, we are able to customize NLSQL technology to SAP HANA or SAP version up from R3 4.0 using SAP RFC module as per your request.
NLSQL could be integrated with multiple ERP or CRM systems same time, so you are able to get relevant information from different sources using only natural language.
Save your time, enjoy your data insights by chatting with your database
In case of any questions please feel free to contact us