eZintegrations
Welcome to eZintegrations, the cloud-based data integration platform that simplifies and streamlines your data processes. The eZintegrations platform offers an intuitive API marketplace for real-time data integration across various cloud platforms, making it easy for organizations to integrate and synchronize their data seamlessly.
With eZintegrations, bid farewell to ETL/ELT complexities and data pipeline hassles. The platform's user-friendly interface facilitates seamless drag-and-drop operations, and its enhanced logging feature ensures real-time issue resolution, making troubleshooting a breeze.
No more navigating APIs, crafting SQL and PL/SQL queries, or wrestling with debugging data sync issues in databases, data warehouses, lakehouses, and data mesh environments. eZintegrations takes care of it all for you.
The eZintegrations platform, a versatile and efficient data integration tool, empowers organizations to streamline their processes and boost productivity.
Data Source - API
Test the Data Source
Follow the mentioned steps to test the Data Source : Step 1: Select the Source Type as API. Ste...
Authorization
eZintegrations platform supports all sort of Authorization for any standard APIs like REST API, S...
Time Parameters
The attributes under Time Parameters of Data Source API are - Today Format Yesterday Format ...
Numeric Parameters
Numeric Parameters of API Data Source has two attributes Minimum Number Maximum Number. Minim...
Pagination
Pagination returns the pages of response. There are 6 types of Pagination in API Data Source of...
Environment Settings
In eZintegrations, environment settings are used to store and manage dynamic values that can be r...
Response Params
Response parameters:It is an API Request parameter to getting the response as per our requirement...
Pre- Request Scripts
Pre-request script is a piece of code that will run before the execution of a request. Pre-reques...
Data Source- Database
Opting for database as a data source in integration involves establishing a connection between th...
Data Source - Bizintel360 Data Lake
Bizintel360 Data Lake is a search engine based NO-SQL database owned by Bizdata. Users can ingest...
Data Source- Websocket
A communication protocol known as WebSocket allows a client and a server to have a single, persis...
Data Source- Email
Setting up Data Source as Email in eZintegrations: By using email as a source, we support ex...
Data Operations
Data Transformation
Upper Case Description This operations helps to convert a given key value into Upper Case from ...
Data Wrangling
Single Line to Multiline Description : Single Line to Multiline operation is used to convert S...
Data Cleaning
Drop All Events to Start With Description: Dropping all events operation is used to drop all t...
Data Pipeline Controls
Sleep Time Description: Sleep Time operation helps in giving a pause of some seconds which is ...
Data Orchestration
Database Description : The Database operation allows users to perform essential SQL actions su...
Deep Learning
Document Understanding Description Document Understanding operation is designed to extract the ...
Bizdata Dataset
Data Target - API
Test the Data Target
Follow the mentioned steps to test the data target: Step 1: Select the Target Type as API. Step...
Pre-Request Script
Pre-request script is a piece of code that will run before the execution of a request. Pre-reques...
REST API Target
When working with OAuth 2.0 and sending data in URL-encoded format, you can provide values in t...
Response Params
Response parameters:It is an API Request parameter to getting the response as per your requiremen...
Data Target- Database
Data Target- Bizintel360 Datalake Ingestion
Data lake ingestion as Data target allows you to efficiently transfer and store data from various...
Data Target- Email
Setting up Data Target as Email in eZintegrations:This feature enables users to receive timely em...
Summary
The Summary Page serves as the concluding stage in the integration service creation process. Foll...
Integration Bridge
Frequency
Frequency is the timing at which the user want their integration bridge to run. It is of 2 types ...
Start An Integration Bridge
Following the selection of the data source, the first step is to launch the integration bridge, w...
Stop An Integration Bridge
After a successful connection is established between the data source and target, in some cases th...
Refresh an Integration Bridge
Refreshing an integration bridge helps with updating all the changes and the path established bet...
Status of Integration Bridge
Status of Integration Bridge aids in displaying the integration's present state. For instance, kn...
Download Logs of An Integration Bridge
Downloading logs of an integration is the process by which the user can download the log files th...
Stream Logs of Integration Bridge
Stream logs of an integration Bridge helps the user to get all the information about ongoing inte...
Copy Integration Bridge
Copy Integration Bridge is designed to copy the entire data from one existing Integration Bridge ...
View An Integration Bridge
View An Integration Bridge helps the user view all the information related to Integration Bridge....
Integration Bridge list - All the buttons
At the initiation of the Integration Bridge process, the primary objective is to activate the int...
Sprintf
Sprintf is a special way of passing the JSON key's value from one step to another step (source/op...
Pycode Examples
Rename JSON Key based on other key's value
In the below python code examples user can dynamically change JSON key based on other key's value...
Generate a OAuth 1.0 Signature or Store a Code Response in a User Defined Variable
When we want to run a python script and the response will come from the same script and has no re...
Convert Empty String in a JSON to a "null" value
Below is the example as how user can convert a empty string to a "null" value in a JSON dataset. ...
Form a JSON Object based on the key and values available in JSON Dataset
Below is the example to form a JSON Object based on the key and values available in the JSON data...
URL Parsing
Below is the example where in the current context, we are receiving a Url in the 'name' key with ...
Form a JSON Object from array of array
Input Data with Singleline Array { "bizdata_dataset": { "values": [["Order ID", ...
Bulk Rename of Keys
In eZintegration, we provide a rename operation, which works well for renaming individual columns...
Split String with Regular Expression
Incoming data { "ip": "xx.249.74.xxx", "hostname": "crawl-xx.249.74.xxx.googlebot.com"...
Extract Domain Name from Email using Split
Incoming JSON Data to Python Operations { "email": "info@bizdata360.com" } Python Operations ...
OnBoarding
Accounting & Billing
Dashboard
This page contains information of the users billing amount, billing cycle, billing period and the...
Plan
First Time User This page has information related to the plans, pricing and payment options. Us...
Current Plan
This page contains information of the current selected plan.
Payment Method
This page has information of the payment method used by the user. Users can update/ change their...
Billing Information
This page contains Billing Information of the selected plan in the format as mentioned below Fir...
Invoices
This page contains information of the Invoices of the plans subscribed. Users can find Invoice I...
Release Notes
Release Notes (September 15, 2023) Improvement: Implemented validation in the summary page un...
Appendix
Connecting Data Sources
Connecting Salesforce as a Source : Step 1 : Choose the Source Type as 'API'. Step 2 : Ente...
Connecting Data Targets
Connecting Oracle Netsuite as a Target : Step 1 : Choose the Target Type as 'API'. Step 2 : E...
Connecting any Database to Database
Information is frequently stored in databases under various architectures, naming standards, and ...
Filter Operation Use Cases
In this guide, we will be discussing various rules and scenarios in which Filter operation can be...
Efficient Column Renaming in eZintegration Using Python Operation
In eZintegration, we provide a rename operation, which works well for renaming individual columns...
Pivot Operation Use Cases
This guide explains the usage of the Pivot Operation, which allows transposing specific data in a...
Management
Adding Users under Organization Admin : Step-by-Step Guide
Step 1 : Click on the three horizontal lines located to the left of the screen, just after the Bi...
Security Matrix
Adding Users and Granting Organization Admin Privileges : Step-by-Step Guide
Step 1 : Click on the three horizontal lines located to the left of the screen, just after the Bi...
DIY Articles
Registering a Salesforce App and Obtaining Client ID / Secret (for API Calls / OAuth)
Register Salesforce App :1. Access your account and navigate to Setup (select the gear icon locat...
Establishing Token-Based Authentication within NetSuite
Use these guidelines to establish communication with Oracle NetSuite, allowing access to retrieve...
Connecting MS-SQL or Oracle Database to Salesforce Using Bizdata Universal API
User Guide: Configuring Source as MS-SQL Database or Oracle Database using Bizdata Universal API ...
Effortless Integration Scheduling: Mastering Biweekly Execution with eZintegrations
IntroductionScheduling integrations at precise intervals significantly streamlines operations and...
Connecting My-SQL to Salesforce Using Bizdata Universal API
User Guide: Configuring Source as My-SQL Database using Bizdata Universal API and Target as Sales...
Overcoming Upsert Limitations: A Case Study on Enabling Upsert Operations in APIs without Inherent Support
Various kinds of APIs are accompanied by diverse approaches. Record creation, updating, and delet...
Connecting Salesforce to Netsuite
User Guide: Configuring Source as Salesforce and Target as Netsuite. This guide offers a deta...
Connecting QuickBooks to Bizintel360 Datalake
User Guide: Configuring Source as QuickBooks and Target as Bizintel360 Datalake. This guide off...
Configuring Salesforce as Source
Configuring Salesforce as the Source: A Comprehensive Guide This guide provides a comprehensive ...
Configuring Netsuite as Source
Configuring Netsuite as the Source: A Comprehensive Guide This guide provides a comprehensive wal...
Integrate Bizintel360
Activation Process for Organization Admin Users Organization Admin users have the authority to...
Marketplace
An API marketplace functions as a dynamic online platform facilitating the exchange of applicatio...