Search 1.7 billion lines of Odoo code on GitHub

base_external_dbsource_mssql

Author: Daniel Reis, LasLabs, Odoo Community Association (OCA)
License: LGPL-3
Branch: 10.0
Repository: 001101/server-tools
Dependencies: base_external_dbsource_sqlite
Languages: PO File (109, 45.4%), Python (77, 32.1%), XML (9, 3.8%), and reStructuredText (45, 18.8%)
Other repositories: 020cui/server-tools, 0yik/server-tools, 111sree/server-tools, 2FM/server-tools, 50611/server-tools, 5songHb/server-tools, AITIC/server-tools, AMhadhbi/server-tools, AcruxLab/server-tools, Albin-John/server-tools, AlceConsorcio/server-tools, Alex-Woo/server-tools, Alfa-90/server-tools, App247/server-tools, ArkanSystem/server-tools, Artielkami/server-tools, Axon-System/server-tools, BCDR/server-tools, Banetese/server-tools, BradooDev/server-tools, Bubbles-IT/server-tools, Burakebf/server-tools, CB-Gran-Canaria/server-tools, CGenie/server-tools, Callino/server-tools, Cedric-Pigeon/server-tools, Cgruppo/server-tools, ChanFeei/server-tools, Chandresh-SerpentCS/server-tools, Change2improve/server-tools, ChinaShrimp/server-tools, CiaranCheng/server-tools, ClearCorp/oca-server-tools, CodeFishEG/server-tools, Colorlessgold/server-tools, ComitorDevTeam/server-tools, CompassionCH/server-tools, Comunitea/server-tools, ContrerasTorrez/server-tools, CrazyJET/server-tools, CustomOdoo/server-tools, DITIntl/server-tools, Danielzhulin/server-tools, Dgaroc/server-tools, Digital5-Odoo/server-tools, Dike90/server-tools, Dobtor-OCA/server-tools, Domatix/server-tools, DucTruongKomit/server-tools, DulingLai/server-tools, EBII/server-tools, ERPLibre/server-tools, EssentNovaTeam/server-tools, Fenkiou/server-tools, FernandoCarlosGarcia/server-tools, FernandoRomera/server-tools, ForgeFlow/server-tools, GSLabIt/server-tools, Gabinete-Digital/server-tools, Gebesa-Dev/server-tools, GleydsonHudson/server-tools, GlobalManager/server-tools, Glue-Software-Engineering-AG/server-tools, Gofekra/server-tools, GowthamKalyan/server-tools, GreyShim/server-tools, GrupoAlvamex/server-tools, GuSWRolland/server-tools, Guobower/OCA-server-tools, HarshalBhoir/server-tools, Hellyna/server-tools, HomerDeoDatu/server-tools, Hothua/server-tools, Ingeos/server-tools, Intesco2-0/server-tools, IvanShirokikh/server-tools, Jagdish-Panchal/server-tools, JaimeAvellaneda/server-tools, Jarsa-dev/server-tools, Jarsa/server-tools, JayVora-SerpentCS/server-tools, Jeisonpernia/server-tools, JibenCL/server-tools, Johnvonthegreat/server-tools, JuaniFreedoo/server-tools, JuniorKRnd/server-tools, Kayuulab/server-tools, KimWu/server-tools, Kiplangatdan/server-tools, Koesj/server-tools, KonaERP/server-tools, Korynkai/server-tools, KottmannM/server-tools, LasLabs/server-tools, LevelPrime/server-tools, LlywelynLi/server-tools, LourenzoH/server-tools, Mahmoud-Alaa-Eldeen/server-tools, Manuel-Dellisse/server-tools, MariajMesa/server-tools, MasterBlaster479/server-tools, MathBenTech/server-tools, MediaJockey/server-tools, Mefistous/server-tools, Melodivo/server-tools, MindAndGo/server-tools, MjAbuz/server-tools, Morgana-Madamal/server-tools, MrFangD/server-tools, NGTS-AUS/server-tools, NL66278/server-tools, NeatNerdPrime/server-tools, Nowheresly/server-tools, Numigi/server-tools, OCA-MUK/server-tools, OCA/server-tools, ORETEK/server-tools, OctoComputer/server-tools, Odoo-Italia-Associazione/server-tools, OdooIndonesia/server-tools, Othniel1796/server-tools, OutillageStEtienne/server-tools, PCatinean/server-tools, PESOL/server-tools, PieterPaulussen/server-tools, PlanetaTIC/server-tools, Ppamungkas/server-tools, PrenorSistemas/server-tools, QubiQ/server-tools, Rad0van/server-tools, RealSolutionsLux/server-tools, Reinhard-sheng/server-tools, RicRichter/server-tools, SHEFFIELDAFRICA/server-tools, SanteLibre/server-tools, Sarfarazsajjad/server-tools, ScopeaFrance/server-tools, SequarSrl/server-tools, SeuMarco/server-tools, SilviaLeonSanchez/server-tools, SilvioGregorini/server-tools, SimoRubi/server-tools, SimoneVagile/server-tools, SokreamPhanqrl/server-tools, SportPursuit/server-tools, StefanRijnhart/server-tools, StephanRozendaal/server-tools, Sunnyshine008/server-tools, Syci-Consulting/server-tools, TDu/server-tools, TRESCLOUD/server-tools, Tecnativa/server-tools, TemosEngenharia/server-tools, Thorncrag/server-tools, TimLai125/server-tools, Tonow-c2c/server-tools, TradePilotLLC/server-tools, UakamiStudio/server-tools, UnknownInfo/server-tools, VanMoof/server-tools, VasiliyKorobatov/server-tools, Vauxoo/server-tools, VisiionSolucionesTecnologicas/server-tools, VitalPet/server-tools, Wadios/server-tools, WiWaG/server-tools, X-ANS/server-tools, Yaman-als/server-tools, YannickB/server-tools, YogeshMahera-SerpentCS/server-tools, a0c/server-tools, aadarsh977/server-tools, aaltinisik/server-tools, abakus-it/server-tools, abdulhalim-cu/server-tools, abdulrhmans/server-tools, acsone/server-tools, acsonefho/server-tools, adekock11/server-tools, adolfoeliazat/server-tools, adriansteel/server-tools, adrienpeiffer/server-tools, agenterp/server-tools, agknz/server-tools, ahmed3bdelhady88/server-tools, aitorbouzas/server-tools, ajaychauhan727/server-tools, ajayjaviya/server-tools, ajinvn2019/server-tools, akhdaniel/server-tools, akhilpsivan01/server-tools, akretion/server-tools, aktaaf/server-tools, alan80080/server-tools, albertvimlet/server-tools, alecvinent/server-tools, alesisjoan/server-tools, alessavindell/server-tools, alexlafalce/server-tools, alfadil/server-tools, alfieqashwa/server-tools, algiopensource/server-tools, alpham/server-tools, altexcorp/server-tools, altoch/server-tools, amcor/server-tools, amebalibre/server-tools, amendoncabh/server-tools, anasallaham/server-tools, anassahmed/server-tools, andriisem/server-tools, angedras/server-tools, anhvu-sg/server-tools, anodino-dev/server-tools, ansinaesmejor/server-tools, antilhue/server-tools, antonyrajserpentcs/server-tools, apachesep/server-tools, apertoso/server-tools, apetbiz/server-tools, arafatx/server-tools, area-scm/server-tools, aremili/server-tools, aroodooteam/server-tools, artux404/server-tools, ateijelo/server-tools, aurestic/server-tools, avanzosc/server-tools, avoinsystems/server-tools, aymanshow/server-tools, azmeuk/server-tools, azuaby/server-tools, bacgdev/server-tools, bacgroup/server-tools, bala07123/server-tools, bangil0/server-tools, bealdav/server-tools, bicomm/server-tools, bishalgit/server-tools-1, bistaray/server-tools, bjccdsrlcr/server-tools, bmya/server-tools, bodi000/server-tools, boky1993/server-tools, boutitinizar/server-tools, brain-tec/server-tools, brainbeanapps/server-tools, bud-e/server-tools, bvkl/server-tools, camptocamp/server-tools, captivea-dcr/server-tools, cedvict/server-tools, chdjdan/server-tools, cheikhousy/server-tools, chenwfal/server-tools, chianggq/server-tools, claro5/server-tools, cocox/server-tools, codewareuae/server-tools, cogitoweb/server-tools, connect-to-ak/server-tools, coopiteasy/server-tools, corsojulian7/server-tools, cristinamartinrod/server-tools, crnd-inc/server-tools, cuongpk/server-tools, dalal-intellisoft/server-tools, damdam-s/server-tools, damendieta/server-tools, danger89/server-tools, dani-xtendoo/server-tools, danimaribeiro/server-tools, daramousk/server-tools, davidwah/server-tools, ddufresne/server-tools, delgerS/server-tools, dennybiasiolli/server-tools, dev-tanvir/server-tools, dev00007/server-tools, devang-dreambits/server-tools, diagramsoftware/server-tools, diegobgl/server-tools, diggy128/server-tools, dipakthapaofficial/server-tools, diverfr/server-tools, dmp16/server-tools, dmsergio/server-tools, dndoanh/server-tools, don-systems/server-tools, dong-z/server-tools, dperaltab/server-tools, dreispt/server-tools, druidoo-dev/server-tools, dsasoftware/server-tools, dsonnet/server-tools, duyhnguyen/server-tools, dynamicats/server-tools, eLBati/server-tools, ebirbe/server-tools, ecosoft-odoo/server-tools, edsersolis/server-tools, elicoidal/server-tools, elperrofarelo/server-tools, emagdalenaC2i/server-tools, enocare/server-tools, erfanjahanshahlo/server-tools, eribowo/server-tools, ermannognan/server-tools, esantos-octagono/server-tools, etobella/server-tools, eversatis/server-tools, ewac-nl/server-tools, exosoftware/oca-server-tools, ezdoo/server-tools, fanha99/server-tools, fashkl/server-tools, felixvillafranca/server-tools, ferdiansahgg/server-tools, findsomeoneyys/server-tools, flosslab/server-tools, fmdl/server-tools, focusate/oca-server-tools, forkme7/server-tools, foutoucour/server-tools, fslibre/server-tools, gab-net/server-tools, gabrielo77/server-tools, gastonfeng/server-tools, gavindav/server-tools, gdgellatly/server-tools, gitguohao/server-tools, goanzaloo/server-tools, gordan-cuic/server-tools, grant-thornton/server-tools, grap/server-tools, grindtildeath/server-tools, groventure/server-tools, guandalf/server-tools, guewen/server-tools, gurneyalex/server-tools, gustavovalverde/server-tools, gxbsst/server-tools, gzanelli/server-tools, habbaba/server-tools, haidd/server-tools, haublang/server-tools, hbrunn/server-tools, hchoog/server-tools, hdb1234/server-tools, henrryyanez/server-tools, hhgabelgaard/server-tools, hibou-io/oca-server-tools, hieulucky111/server-tools, hiisoc/server-tools, hilarak/server-tools, hinfo506/server-tools, hippe-67/server-tools, hokhyk/server-tools, hq8399/server-tools, huntergps/server-tools, hvcabaim/server-tools, i-vyshnevska/server-tools, iRichGit/server-tools, ibanh/server-tools, ideaspositivas-group/server-tools, igallart/server-tools, igor-mitin/server-tools, ilmir-k/server-tools, initOS/server-tools, insscn/server-tools, intero-chz/server-tools, invitu/server-tools, ip-candres/server-tools, itblabla/server-tools, ixor3/server-tools, izzihector/server-tools, j-zaballa/server-tools, jaballate/server-tools, jackxusho/server-tools, jacky82669513/server-tools, janverb/server-tools, jaosss/server-tools, jcarlosmontoya/server-tools, jeanpaul-mupagasi/server-tools, jeroen7s/server-tools, jesmar81/server-tools, jimmyec/server-tools, jmorgannz/server-tools, jnegrete/server-tools, jonathanjbbr/server-tools, joshuajan/server-tools, josueBulle/server-tools, josuf567/server-tools, jphatig/server-tools, jriveros/server-tools, julenalgios/server-tools, julianram/server-tools, kait-avalah/server-tools, kamilmuhammed/server-tools, kamsir/server-tools, kararaMohamed/server-tools, katyukha/server-tools, kelldave/server-tools, kevin070982/server-tools, kikopeiro/server-tools, kmee/server-tools, kos94ok-3D/server-tools, lasley/server-tools, lawrencekm/server-tools, leemannd/server-tools, legalsylvain/server-tools, lembregtse/server-tools, leonidasthe300/server-tools, lfreeke/server-tools, libregob/server-tools, lideritjnma/server-tools, liehu1/server-tools, lilotter45/server-tools, lincersolucoes/oca-server-tools, liweijie0812/server-tools, loftwah/server-tools, lonelyleaves/server-tools, luistorresm/server-tools, lukebranch/server-tools, magedmnb/server-tools, magnuscolors/server-tools, maherjaballi/server-tools, mamcode/server-tools, marcelomora/server-tools, marionumza/server-tools, mart-e/server-tools, maulik-raval/server-tools, mehdi-ghezal/server-tools, michotm/server-tools, mikolodz/server-tools, minhyk/server-tools, minorisa/server-tools, mivilsoft/server-tools, mjadily/server-tools, modoolar/server-tools, mohamedhagag/server-tools, monksoftware/server-tools, mozaik-association/server-tools, msdeek/server-tools, mulaudzicalvin/server-tools, mvaled/server-tools, myonnet/oca-server-tools, mysticalis/server-tools, nabiforks/server-tools, nabima/server-tools, nadiaafa/server-tools, nebras-solutions/server-tools, necrodevz/server-tools, nehaksolves/server-tools, netoodoo/server-tools, newtratip/server-tools, nguyenductamlhp/server-tools, nicolasjelincic/server-tools, nilshamerlinck/server-tools, niulinlnc/server-tools, njeudy/server-tools, nodoo/server-tools, novacode-nl/server-tools, novawish/server-tools, ntsirintanis/server-tools, nuobit/server-tools, odof/server-tools, odoo-brazil/server-tools, odoo247/server-tools, odooerpdevelopers/server-tools, odoogap/server-tools, odoosoft/server-tools, odoospace/server-tools, omalbastin/server-tools, onaconsulting/server-tools, one2pret/server-tools, onesteinbv/server-tools, ontruck/server-tools, onurugur/server-tools, open-net-sarl/server-tools, open2bizz/server-tools, osbzr/gooderp_extra, osfp-Pakistan/server-tools, osiell/server-tools, osipaas/server-tools, ovnicraft/server-tools, p-tombez/server-tools, pedrocasi/server-tools, percypalomino/server-tools, phillipstack/server-tools, phucngta/server-tools, piensom/server-tools, popcomputadores-desenv/server-tools, praxigento/oca-server-tools, presenceverte/server-tools, programadorzurita/server-tools, pscloud/server-tools, pythoner-3k/server-tools, qtheuret/server-tools, quentinDupont/server-tools, raizs/server-tools, ravibhattarai/server-tools, ravishekharco/server-tools, raycollazo/server-tools, rdeheele/server-tools, redcor/server-tools, revstech/server-tools, rezaakba123/server-tools, richar-osse/server-tools, rifki/server-tools, rm-jamotion/server-tools, robertsvx27/server-tools, romendil/server-tools, ronozoro/server-tools, roussel2nis/server-tools, royalline1/server-tools, rrcfesc/server-tools, rrgaona/server-tools, rsmolyazhenko/server-tools, rsullivan2704/server-tools, rudisulistyo/server-tools, ruifranco/server-tools, rven/server-tools, rwfnf/server-tools, rwsdigital/odoo-server-tools, sadeqamin/server-tools, sailguest/server-tools, saltonmassally/server-tools, sanube/server-tools, savoirfairelinux/server-tools, schout-it/server-tools, sebalix/server-tools, selim-b/server-tools, serpentcs-dev1/server-tools, sewisoft/server-tools, shepilov-vladislav/server-tools, simahawk/server-tools, simone/server-tools, skmezanul/server-tools, skukered/server-tools, skyoj/server-tools, smile-888/server-tools, smurf-U/server-tools, soeethiha/server-tools, solvosci/server-tools, spacemonkeythe/server-tools, ssaid/server-tools, steingabelgaard/server-tools, striqo/server-tools, sunflowerit/server-tools, sunshineLhj/server-tools, superjiel/server-tools, suprielfath/server-tools, swbs-co/server-tools, sylvainvh/server-tools, sysprocesarcastro/server-tools, t-np/server-tools, tafaRU/server-tools, takinobori/oca-server-tools, tansadio/server-tools, tarteo/server-tools, tegin/server-tools, thinkopensolutions/oca-server-tools, tirma-sa/server-tools, tmasson/server-tools, tongjiou/server-tools, tqngoc/server-tools, traviswaelbro/server-tools, trevi-software/server-tools, tschanzt/server-tools, tsengeagle/server-tools, tuanna7593/server-tools, tusharkwagh99/server-tools, unitek-solusi/OCA-server-tools, ursais/server-tools, valenciaricardos/server-tools, valentinthirion/server-tools, valmarnet/server-tools, vcloud9ray/server-tools, vdedyukhin/server-tools, ventor-tech/server-tools, versada/server-tools, victoralmau/server-tools, vinaybhawsar/server-tools, vmelnych/server-tools, westlyou/server-tools, widiana/server-tools, wilcobergacker/server-tools, willmakenoise/server-tools, wowerliu/server-tools, wuhuizhong/server-tools, www3838438/server-tools, xAlphaOmega/server-tools, xcgd/server-tools, xhair/server-tools, xichun/server-tools, xtjie/server-tools, xuanmu/server-tools, xwh123807/server-tools, xwh1238070/server-tools, yalabsio/server-tools, ycp1015/server-tools, yelizariev/server-tools, ygdmxy/server-tools, yogakumboro/server-tools, yogesh-serpentcs/server-tools, ypapouin/server-tools, yusniermatos/server-tools, yuzhengxing/server-tools, yvaucher/server-env, yvaucher/server-tools, zakiuu/server-tools, zambee/server-tools, zamberjo/server-tools, zarumaru/server-tools, zeroincombenze/server-tools, zhaohengzeng/server-tools, zhaohuaw/server-tools, zhujin001032/server-tools, and zmakan-p/server-tools

License: LGPL-3

External Database Source - MSSQL

This module extends base_external_dbsource, allowing you to connect to foreign MSSQL databases using SQLAlchemy.

Installation

  • Install & configure FreeTDS driver (tdsodbc package)
  • Install sqlalchemy and pymssql python libraries
  • Install base_external_dbsource_sqlite Odoo module

Configuration

Database sources can be configured in Settings > Configuration -> Data sources.

Usage

To use this module:

  • Go to Settings > Database Structure > Database Sources
  • Click on Create to enter the following information:
  • Datasource name
  • Pasword
  • Connector: Choose the database to which you want to connect
  • Connection string: Specify how to connect to database
Try me on Runbot

Known issues / Roadmap

  • Add X.509 authentication

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback.

Credits

Contributors

Maintainer

Odoo Community Association

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

To contribute to this module, please visit http://odoo-community.org.