Authors :
Onyeacholem Ifeanyi Joshua
Volume/Issue :
Volume 8 - 2023, Issue 4 - April
Google Scholar :
https://bit.ly/43uxUln
Scribd :
https://bit.ly/3GRbFMX
DOI :
https://doi.org/10.5281/zenodo.7845100
Abstract :
Over the years the role of data when it comes
to analysis, interpretation, and prediction can’t be
overemphasized, the effectiveness and the interaction of
any application hinged on inputting and outputting data
to ascertain its functionalities and robustness. We are
looking at how we can create data and get it inserted into
two different databases same time, with the same data
type without any constraint, this is very important where
we have a cloud (server database) that only takes input
from a particular technology, say (.Net Framework) and
we have another solution running on PHP technology. In
this paper, we were able to implement different
applications technology to exchange data from two
different databases so as to communicate seamlessly with
each other through API (Application Program Interface).
The need to fetch data between two applications is to
enable two applications to communicate seamlessly
without interference and alteration from one application
database to the other. The role of API is like giving a
visitor your house key but the visitor can only enter the
room that the key is meant for (not the whole room), for
the cause of this paper we used MySQL Server database
and MySQLi database (Maria DB) and the result on
Scalability and Performance of these two databases
synchronization was accurate.
Keywords :
Authentication; SQL; Server; Database; API; curl; Microsoft.
Over the years the role of data when it comes
to analysis, interpretation, and prediction can’t be
overemphasized, the effectiveness and the interaction of
any application hinged on inputting and outputting data
to ascertain its functionalities and robustness. We are
looking at how we can create data and get it inserted into
two different databases same time, with the same data
type without any constraint, this is very important where
we have a cloud (server database) that only takes input
from a particular technology, say (.Net Framework) and
we have another solution running on PHP technology. In
this paper, we were able to implement different
applications technology to exchange data from two
different databases so as to communicate seamlessly with
each other through API (Application Program Interface).
The need to fetch data between two applications is to
enable two applications to communicate seamlessly
without interference and alteration from one application
database to the other. The role of API is like giving a
visitor your house key but the visitor can only enter the
room that the key is meant for (not the whole room), for
the cause of this paper we used MySQL Server database
and MySQLi database (Maria DB) and the result on
Scalability and Performance of these two databases
synchronization was accurate.
Keywords :
Authentication; SQL; Server; Database; API; curl; Microsoft.