Hi Lipsa, You need to create separate data sources for each DB[2]. Then inside your mediation logic (proxy, api), incorporate result from both these datasources.
[2] - https://docs.wso2.com/display/EI600/Exposing+an+RDBMS+as+a+Data+Service /Vinod On Thu, Jun 29, 2017 at 1:18 PM, Lipsa Pradhan < [email protected]> wrote: > I got this but it works only if the databases in one single RDBMS such as > MySQL. I want to fetch data from MySQL and Oracle as well. > How to do this? > > > > On Thu, Jun 29, 2017 at 11:47 AM, Vinod Kavinda <[email protected]> wrote: > >> Hi Lipsa, >> Is it you need to fetch data from several DBs in your integration logic? >> If that is the case, you can use data services in EI. Refer [1]. >> >> [1] - https://docs.wso2.com/display/EI600/Data+Integration+Tutorials >> >> Regards, >> Vinod >> >> On Thu, Jun 29, 2017 at 11:43 AM, Danushka Fernando <[email protected]> >> wrote: >> >>> I think you are looking for [1]. You can configure multiple secondary >>> userstores. >>> >>> [1] https://docs.wso2.com/display/ADMIN44x/Configuring+Secon >>> dary+User+Stores >>> >>> Thanks & Regards >>> Danushka Fernando >>> Associate Tech Lead >>> WSO2 inc. http://wso2.com/ >>> Mobile : +94716332729 <+94%2071%20633%202729> >>> >>> On Thu, Jun 29, 2017 at 11:39 AM, Lipsa Pradhan < >>> [email protected]> wrote: >>> >>>> User related data.. >>>> >>>> On Thu, Jun 29, 2017 at 11:23 AM, Danushka Fernando <[email protected] >>>> > wrote: >>>> >>>>> Hi Lipsa >>>>> What kind of data you want to fetch from those dbs? Do you want to >>>>> expose data as service or do you want to fetch some user related data from >>>>> those dbs? >>>>> >>>>> Thanks & Regards >>>>> Danushka Fernando >>>>> Associate Tech Lead >>>>> WSO2 inc. http://wso2.com/ >>>>> Mobile : +94716332729 <+94%2071%20633%202729> >>>>> >>>>> On Thu, Jun 29, 2017 at 11:15 AM, Lipsa Pradhan < >>>>> [email protected]> wrote: >>>>> >>>>>> Hello All, >>>>>> >>>>>> Can we connect different databases to EI server? >>>>>> >>>>>> Actually, I want to fetch data from different DB such as some from >>>>>> MySQL, some from Oracle and so on. >>>>>> >>>>>> And one more thing, I don't want to change the default DB i.e, the H2 >>>>>> DB and want to fetch data from different DBs (maybe as external DB , if >>>>>> possible). >>>>>> >>>>>> Regards >>>>>> Lipsa Pradhan >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> [email protected] >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>> >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Vinod Kavinda >> Senior Software Engineer >> *WSO2 Inc. - lean . enterprise . middleware <http://www.wso2.com>.* >> Mobile : +94 (0) 712 415544 >> Blog : http://soatechflicks.blogspot.com/ >> [image: http://wso2.com/signature] >> <http://wso2.com/signature> >> >> > -- Vinod Kavinda Senior Software Engineer *WSO2 Inc. - lean . enterprise . middleware <http://www.wso2.com>.* Mobile : +94 (0) 712 415544 Blog : http://soatechflicks.blogspot.com/ [image: http://wso2.com/signature] <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
