For a more indepth discussion, read our documentation on managing sql databases using octopus. A flyway step template for octopus deploy to migrate. Our robust finance management software manage to create financial accounting, ease finance operations, shares prossesing, inter bank branch operations. This database will be used as target for schema comparison with the database in the package. You not only able to obtain country specific data, but also detail. Octopus microfinance suite free download windows version. But sometimes new tables are added for a new version. First, you will learn how to script common database changes. Fortunately, i found that octopus has a lot of flexibility and supports schema changes very well as one might hope. Loan performer is the number 1 microfinance software for mfi. If you are doing your database development in ssms, you can use a mix of tools to set up the functionality in vsts. Octopus microfinance browse octopus setup updatev4.
The list contains both open sourcefree and commercialpaid software. Since 2006, octopus has successfully assisted 120 institutions in establishing greater efficiency, transparency and timely reporting. The system integrity check at configuration,diagnostics will let you know if the database schema has drifted from its intended state. Mambu revamps its microfinance software free mambu microfinance software for all the little guys finally, all the small mfis, ngos and microfinance dogooders out there can have access to technology to manage their clients and portfolios for free. Octopus describes itself as a nextgeneration mis for microfinance. How to use octopus deploy step templates for sql release. Octopus microfinance was created to run microfinance institutions mfi. Adaptable microfinance software that provides efficiency in business processes, risks mitigation and operational control. The create database release step for octopus is slow.
Rolling back a database deployment is one the most complicated topics with automated database deployments. A project can have only one homepage link, and only one downloads link, but. Just upgraded a 2 year out of date instance and migrated it to a new server and it. As such, a better approach is to use nuget and tools like octopus deploy to store, track, and deploy dacpacs. You can edit this template and create your own diagram. Teamcity and octopus autodeployment work with schema level restrictions. Automated database schema migrations octopus deploy. Microfinance software loan management solutions arttha. If you feel that you are already struggling with making your database as part of your continuous delivery story, definitely try dlm automation suite and sql release out.
The software lies within business tools, more precisely finances. With the help of capterra, learn about cobis microfinance software, its features, pricing information, popular comparisons to other banking systems products and more. Free microfinance systems in titlesummary octopus microfinance suite the suite enables you to benefit from improved loan, savings portfolio management, interactive client relationship management, integrated accounting and proactive risk management. Octopus is the foremost providers of mis technology for microfinance institutions. With stateoftheart technology the microfinance software delivers operational transformation to microfinance organizations of all sizes, by adding high service value and financial regulatory compliance.
Mostfit see also our offical website is an mis for micro finance institutes mfis it has originally been created by intellecaps technology solutions group which has since 2011 been made into a company of its own called istpl. Sql server database octopus works with a wide range of versions and editions of sql server, from a local sql server express instance, all the way to an enterprise edition sql server failover cluster or sql server alwayson availability group, or even one of the hosted databaseasaservice offerings. The system integrity check at configuration diagnostics will let you know if the database schema has drifted from its intended state. Microfinance software, rd fd software, banking software, co. From the beginning, the idea was not only to bring an outstanding tool for a specific mfi in tajikistan, afghanistan and kirgizstan, but to provide a general purpose mis suitable for all microfinance. Asset management editable database diagram template on creately.
It is just as easy to rollback database schema changes using redgates database lifecycle management. Government under vendors standard commercial license. Exclude schema from deploying with octopus stack overflow. Octo technology started the octopus project in 2005 with oxus, a subsidiary of a large french ngo acted with a strong microfinance presence in central asia. Hi, im attempting to deploy a database schema plus static data to an empty database.
Valid license from hp required for possession, use or copying. When our octopus deploy pilot started, one of my first questions was exactly how octopus would update our database schemas. Within the microfinance sector, the mix market is responsible for collecting and disseminating financial data on microfinance institutions, and its database is the largest industry data source on the finances of microfinance institutions. Jul 07, 2017 download octopus microfinance for free. Apr 04, 2018 download mifos microfinance open source for free. Mambu has just launched its revamped community edition which gives an organization of up to 1500 clients, access.
I have a visual studio database project that has a schema generated automatically with tables and stored procedures. An ebook reader can be a software application for use on a computer such as microsofts free reader application, or a booksized computer. Octopus octopus is a benchmark in the microfinance software. By tests, i mean testing the code that uses the schema, but also testing the schema itself. Opencbs cloud is a webbased solution which delivers high performance combined with an enjoyable user experience. We are starting to integrate our sql server workflow with git, by which i mean generating scripts for all objects and storing them in a git repository so you can pull. Octopus microfinance suite is a comprehensive mis solution that supports all aspects of your microfinance operations. The data are from the global database of microfinance institutions collected by the mix market. Its there any way that i can specify a schema name that i dont want to be deployed with octopus deploy. We keep on developing it to help them and maintain its adaptability to their specificities. It seems there may be almost as many different ways to change a schema as there are software companies.
Microfinance demo, microfinance features, microfinance. The octopus microfinance suite open source project on open hub. The software is also available as a freetouse version, and is available in an open source version too, which creates space for improvement. Database schema changes check out database changes 5 known bugs and shortcomings while running patches, make sure you understand what you do and perform systematically backup before applying it. How to deploy complex databases w octopus pluralsight. Can anyone suggest me some database for microfinance. Adaptive, open source software for microfinance opencbs is the easiest financial management solution to install, use and customize. Weve just published a 46 minute youtube video, reusable schema deployments with sql source control and octopus deploy which gives you a view of this at work. Discover hpcc systems the truly open source big data solution that allows you to quickly process, analyze and understand large data sets, even data stored in massive, mixedschema data lakes. Download at the below link octopus installation guide. The code is rather easy to rollback, just deploy the previous version of the code package and call it good. Our microfinance software solution is a robust and scalable platform that helps to automate all business processes of your organisation on a single technology backbone, thereby helping you to plan your business growth at lower investments, enhance customer reach multifold in a secure manner and keep track of the profitability as well as. The most popular versions among octopus microfinance suite users are 4. It is open source and users can build and modify it as per their requirements.
Our active portfolio is monitored accurately and we are able to make future assumptions based on historic data, making precise risk assessment. An ebook reader can be a software application for use. Our fin soft software has already been tested upon huge database and complex data, making the system more robust and powerful. The suite enables you to benefit from improved loan, savings portfolio management, interactive client relationship management, integrated accounting and proactive risk management. Designed by data scientists, hpcc systems is a complete integrated solution from data ingestion and data processing to data delivery. Obviously, sql release and its octopus deploy step templates make it easier to integrate with octopus deploy for deploying database schema changes in a safe and reliable way. Sql release is essentially using the sql compare comparison engine under the covers, its currently performing more database schema parsing, comparison and reporting steps than either sql ci or when calling sqlcompare. The software that has been used by many mfis in clientserver architecture has been upgraded to an omnipresent. We set up a manual intervention step in octopus deploy, which allowed us to view and approve the database delta scripts prior to deploying. This is a database that you are happy for octopus flyway to clean delete all the objects and rebuild each time you deploy. This can be done with a variety of orchestrators in this example the use case is to have octopus deploy manage the release orchestration. Thanks to the commitment of our team, the support of funders, and the dedication of financial.
Microfinance institutions supply banking services for small customers. Octopus microfinance develops software both for microfinance institutions mfis around the world. Make database code reusable in sql source control with. Loan performer wont overwrite your old database, that is not the problem. Financial services includes small loan, credits, saving, fund transfers and insurance. Micro finance loan entry is used for the group of people. Trusted windows pc download octopus microfinance suite 4.
About octopus microfinance suite octo technology started the octopus project in 2005 with oxus, a subsidiary of a large french ngo acted with a strong microfinance presence in central asia. Octopus micro finance suite omfs is an open source lgpl micro finance it software. It was a little harsh, but it guaranteed the database schema matched what was in source control. I cant delete it directly from project because it verifies the dependencies at build time. Practical octopus deploy database change scripts russ. In a bid to support and accelerate the growth of small startup mfis, loan performer has been made free of charge for small micro finance organisations. Use the secure microfinance software in india to increase profitability of your finance business. This software is available to the community of micro finance institutions. Next, you will discover how to execute and track these scripts using dbup. The octopus microfinance suite installer is commonly called octopus. Open source financial software for personal financial management.
Sql server express free or sql server 2005 reports. It explains the nature of the microfinance sector structure using the diversity of the mis packages which have evolved to meet its specific needs. Open source fitness management software free download. This free software was originally created by octopus. Through mix marketthe microfinance data service operated by mix and covering thousands of financial service providersdozens of data points for each provider have been collected, analyzed, and reported for more than 15 years.
Octopus microfinance is a spinoff from the oxus group, a global network of microfinance institutions created by acted, a. Octopus user guide thank you for choosing octopus, a stored value facility svf that can be used as a means of payment on public transport, at retail shops, tunnels, car parks, parking meters, selfservice kiosks and as staff cards and access control cards for residential and commercial premises. Our technology is used by all kinds of institutions, from small startups using our free core software to microfinance. Octopus microfinance suite functionalities overview. This mis software is very versatile and can be customised as per the requirements of the mfi. Mifos is a community of of microfinance institutions, technology professionals, business people, volunteers, and contributors with a vision to create and deploy technology that allows the microfinance industry to scale. Microfinance software micro banking finance solutions. If they do not match your target database has drifted.
Octopus server maintains its own schema it will create the initial database schema upon installation, and it will update the schema when you upgrade octopus server. Octopus microfinance suite free opensource mis software. Microfinance software mlm software, mlm binary software. Mifos x is the next generation of the mifos software. Now, since the main purpose of the octopus deploy system is to deploy same package, in this case database changes, to multiple targets at once this specific database can be on any of the target machines. Octopus mfs is an integrated suite allowing full management of a micro finance institution. Microfinance solutions microfinance software in india by nelito. How to have sql server with git, teamcity and octopus auto. Microfinance is a financial systems which supplements both financial and nonfinancial services.
Our international clients range from greenfield institutions to established tier2, tier3, and tier4 microfinance organisations. Open hub will display links on the projects summary page, near the top. Redesigned to be a true, fully functional platform for financial inclusion, it builds off the experiences of our legacy codebase, mifos 2. European microfinance week mis for mfis jean pouit. Microfinance management system with php and mysql database duration. Aspekt microfinance software i workflow technology for loan. Mar 27, 2012 mifi, is a proven, established, complete microfinance software solution for mfis. The octopus microfinance suite open source project on open. Octopus can be used to orchestrate database changes using both approaches, and using a variety of tools. Business software downloads octopus microfinance suite by octopus and many more programs are. Octopus microfinance suite free opensource mis software for mfi. The cloud solution will be available in english, french, russian and arabic. An ebook reader can be a software application for use on a computer such as microsofts free reader application, or a booksized computer that is used solely as a reading device such as nuvomedias rocket ebook.
Emergency fixes that were due to a random view or stored procedure being missed dropped to almost zero. Dbas and developers in database continuous delivery. It should help in lowering transaction costs and interest rates. Cyclos is a scalable and reliable banking software solution that comes with a pack of powerful features.
Pucca can be a really trendy game three game for android devices in which you have to accomplish increasingly difficult requirements so as to succeed throughout the stages. Octopus micro finance suite free download and software. Octopus micro finance suite orbit orchid microfinance pharafinance sasapro vision 2003 savco savings plus siem 5. Opencbs is a fork of the last opensource version of octopus microfinance suite, which started in 2006. Non financial services include business training,to improve their businesses, income and assets, health, nutrition, family planning, education of children. We are persuaded that micro finance is one of the best answers for helping poor people improving their life conditions. Microfinance software company provides advanced services in micro finance software solutions of all types. There are excuses, in the database world, for breaking these rules. Developed with cuttingedge technologies and relying on agile methodology, octopus is used by hundred of microfinance institutions worldwide. Aspekt microfinance software is specialized, microfinance sof. Dbas and developers in database continuous delivery pipeline tools. Since 2006, octopus has successfully assisted 120 institutions in octopus microfinance browse octopus setup update v4.
We use your linkedin profile and activity data to personalize ads and to show you more relevant ads. Use pdf export for high quality prints and svg export for large sharp images or embed your diagrams anywhere with the creately viewer. A flyway step template for octopus deploy to migrate databases, with a drift check. Octopus main goal is to help micro finance development by providing a free, easy to use and powerful it software. The most important source of microfinance data is mix market, its a specialized database for microfinance institutions. Stack overflow for teams is a private, secure spot for you and your coworkers to find and share information. Jason crease demonstrates how to build and deploy a simple database into the test environment using sql ci, sql source control, octopus deploy, tsqlt, sql cop and sql release, all with the minimum of hassle and effort. Microfinance is a sector where mis is a strategic need for up scaling to get both economic sustainability and social outreach and performance. Is there a way where the database references in a sql server database project dacpac can be derived at run time. Creately diagrams can be exported and added to word, ppt powerpoint, excel, visio or any other document. Get octopus microfinance suite alternative downloads. Note that it requires a sql database in order to run.
Fully supported audit trail on all transactions integrated module of database management by the octopus expert team. At first we need to create a micro finance group by giving the data with certain group name, principal, interest and number of persons. The mid and longterm vision is to convert the program into a platform through a serviceoriented architecture. At present, various microfinance institutions agree to the notion that offering of digital financial services is highly convenient, efficient, and the way forward. You now have two databases that should contain identical schema objects. With aspekt microfinance software, we have complete control over the corporate portfolio. Since 2006, we have assisted over 90 institutions in establishing greater efficiency, transparency and timely reporting. Redgate tools, git, teamcity and octopus deploy in past few months i have been involved with various clients in enabling continuous integration and continuous. Octopus microfinance suite functionalities overview 1.
Octopus schema version information in the master database defined in the database. In this course, deploying databases with octopus, you will gain the ability to perform complex database synchronizations against your database servers. In addition to standard erp features, this app also offers crm, mrp, scm and product design management. A study of the mis for this sector is therefore crucial. If you copy them into the old datadirectory, the database container is not updated and the new files are not listed as belonging to the loan performer database.
93 689 1359 277 965 427 328 836 68 711 1130 586 1609 94 297 1201 76 308 1621 1195 1145 79 1642 684 1403 79 1315 93 1291 744 1561 1145 942 965 1333 1421 472 863 862 12 422 643 1334 21 1317 1382