You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Karthik Ananthakrishnan <ka...@beyondsquare.com> on 2017/11/22 15:33:13 UTC
Fineract - MySQL to Oracle.
Hello all,
I am planning to build a lending platform on top of Fineract (https://github.com/apache/fineract). We want to change the DB from MySQL to Oracle. Has anyone in the group attempted this before.? If yes, do you have the steps so that I don’t have to re-invent the wheel again.
People who are aware of the changes required can also please let me know the steps. Will be helpful and can be a starting point for me.
Thanks in advance.
Regards,
Karthik
Re: Fineract - MySQL to Oracle.
Posted by Markus Geiss <ma...@apache.org>.
Hey Karthik,
as mentioned earlier in our conversation ... for now Apache Fineract 1.x
is using native SQL within the code so you'd need to replace all of this.
In addition all migrations scripts written in native SQL for MySQL utilizing
flyway to process them.
With the next generation, Apache Fineract CN, you would only need to
add new migration scripts for Oracle and change the underlying DB reference.
Cheers
Markus
.::Yagni likes a DRY KISS::.
On Wed, Nov 22, 2017 at 5:00 PM Karthik Ananthakrishnan <
karthik.a@beyondsquare.com> wrote:
> Thanks Sendoro,
>
> I can see there is a Persistence layer(Open JPA) in Apache Fineract. So, I
> can replace MySQL with Oracle with some effort.
>
> I am looking for help/info if anyone has successfully done it before and
> if yes, would like to understand the changes required so that I don’t have
> to re-invent the wheel or have a starting point.
>
> Regards,
> Karthik
>
> On 22/11/17, 9:25 PM, "Sendoro Juma" <se...@singo.africa> wrote:
>
> Hell Karthik,
>
>
> To be specific these were answers see 1. and 2. below:
>
> 1. advise From Ed.
> --------------START-------------
> Orlando,
>
> Depending on what your use cases are and your timeline for
> implementation,
> the forthcoming Apache Fineract CN architecture is relational database
> agnostic so you could more easily swap out MySQL for another database
> like
> SQL server.
>
> Ed
> ----------- END-------------
>
>
>
> 2. Response fro Markus
>
> ------------START------------
> Hey,
>
> the issue is, that the current version is using native SQL within the
> code
> ... so it will get hard to replace the DB without a lot of refactoring.
>
> Cheers
> ------------END---------------
>
> Best Regards
> Sendoro
>
>
> ----- Original Message -----
> From: "karthik" <ka...@beyondsquare.com>
> To: dev-help@fineract.apache.org, "dev" <de...@fineract.apache.org>
> Sent: Wednesday, November 22, 2017 5:33:13 PM
> Subject: Fineract - MySQL to Oracle.
>
> Hello all,
>
>
>
> I am planning to build a lending platform on top of Fineract (
> https://github.com/apache/fineract). We want to change the DB from MySQL
> to Oracle. Has anyone in the group attempted this before.? If yes, do you
> have the steps so that I don’t have to re-invent the wheel again.
>
>
>
> People who are aware of the changes required can also please let me
> know the steps. Will be helpful and can be a starting point for me.
>
>
>
> Thanks in advance.
>
>
>
> Regards,
>
> Karthik
>
>
>
>
Re: Fineract - MySQL to Oracle.
Posted by Karthik Ananthakrishnan <ka...@beyondsquare.com>.
Thanks Sendoro,
I can see there is a Persistence layer(Open JPA) in Apache Fineract. So, I can replace MySQL with Oracle with some effort.
I am looking for help/info if anyone has successfully done it before and if yes, would like to understand the changes required so that I don’t have to re-invent the wheel or have a starting point.
Regards,
Karthik
On 22/11/17, 9:25 PM, "Sendoro Juma" <se...@singo.africa> wrote:
Hell Karthik,
To be specific these were answers see 1. and 2. below:
1. advise From Ed.
--------------START-------------
Orlando,
Depending on what your use cases are and your timeline for implementation,
the forthcoming Apache Fineract CN architecture is relational database
agnostic so you could more easily swap out MySQL for another database like
SQL server.
Ed
----------- END-------------
2. Response fro Markus
------------START------------
Hey,
the issue is, that the current version is using native SQL within the code
... so it will get hard to replace the DB without a lot of refactoring.
Cheers
------------END---------------
Best Regards
Sendoro
----- Original Message -----
From: "karthik" <ka...@beyondsquare.com>
To: dev-help@fineract.apache.org, "dev" <de...@fineract.apache.org>
Sent: Wednesday, November 22, 2017 5:33:13 PM
Subject: Fineract - MySQL to Oracle.
Hello all,
I am planning to build a lending platform on top of Fineract (https://github.com/apache/fineract). We want to change the DB from MySQL to Oracle. Has anyone in the group attempted this before.? If yes, do you have the steps so that I don’t have to re-invent the wheel again.
People who are aware of the changes required can also please let me know the steps. Will be helpful and can be a starting point for me.
Thanks in advance.
Regards,
Karthik
Re: Fineract - MySQL to Oracle.
Posted by Sendoro Juma <se...@singo.africa>.
Hell Karthik,
To be specific these were answers see 1. and 2. below:
1. advise From Ed.
--------------START-------------
Orlando,
Depending on what your use cases are and your timeline for implementation,
the forthcoming Apache Fineract CN architecture is relational database
agnostic so you could more easily swap out MySQL for another database like
SQL server.
Ed
----------- END-------------
2. Response fro Markus
------------START------------
Hey,
the issue is, that the current version is using native SQL within the code
... so it will get hard to replace the DB without a lot of refactoring.
Cheers
------------END---------------
Best Regards
Sendoro
----- Original Message -----
From: "karthik" <ka...@beyondsquare.com>
To: dev-help@fineract.apache.org, "dev" <de...@fineract.apache.org>
Sent: Wednesday, November 22, 2017 5:33:13 PM
Subject: Fineract - MySQL to Oracle.
Hello all,
I am planning to build a lending platform on top of Fineract (https://github.com/apache/fineract). We want to change the DB from MySQL to Oracle. Has anyone in the group attempted this before.? If yes, do you have the steps so that I don’t have to re-invent the wheel again.
People who are aware of the changes required can also please let me know the steps. Will be helpful and can be a starting point for me.
Thanks in advance.
Regards,
Karthik