[{"_1":2,"_153":-5,"_154":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_132":133},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_125":-5,"_126":11,"_127":17,"_128":11,"_129":-5,"_130":131},"canonicalUrl","https://hub.docker.com/r/buildersoftdev/andyx-mssql-source-connector/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","buildersoftdev","reponame","andyx-mssql-source-connector","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":58,"_60":61,"_62":-5,"_63":64,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2022-11-24T23:56:04.146959Z","description","Microsoft SQL Server Source Connector for Andy X","is_private","last_updated","2022-11-25T00:00:46.947214Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",869,"repository_type","star_count",1,"status","status_description","active","source","collaborator_count",0,"full_description","

\n $\"Sublime's$ \n

\n\nWhat is Andy X MSSQL Connector?\n============\n\nAndy X is an open-source distributed streaming platform designed to deliver the best performance possible for high-performance data pipelines, streaming analytics, streaming between microservices and data integrations. Andy X MSSQL Source Connector is an open source distributed platform for change data capture. Start it up, point it at your databases, and your apps can start responding to all of the inserts, updates, and deletes that other apps commit to your databases. Andy X MSSQL Source Connector is durable and fast, so your apps can respond quickly and never miss an event, even when things go wrong.\n\nAndy X MSSQL Connector works only with version 3 or later of Andy X.\n\n## Get Started\n\nFollow the [Getting Started](https://andyx.azurewebsites.net/) instructions how to run Andy X.\n\nFor local development and testing, you can run Andy X within a Docker container, for more info click [here](https://hub.docker.com/u/buildersoftdev)\n\nAfter you run Andy X you will have to configure Andy X MSSQL Source Connector. Configuring this adapter is quite easy only to json files need to be configured dbengine_config.json and andyx_config.json\n> dbengine_config.json - SQL Connection Configuration file, it's the file where we specify tables which this adapter will check the changes and produce them.\n\n> andyx_config.json - Andy X Configuration File, it's the file where we specify the connection with Andy X.\n\n### Database Engine Configuration File\nBelow is an example of configuration file, this file should be saved into config directory of Andy X MSSQL Source Connector before running this service.\n\n```json\n{\n \"Servers\": [\n {\n \"Name\": \"MSSQL\",\n \"ConnectionString\": \"Data Source=localhost;Initial Catalog={databaseName/master};Integrated Security=False;User Id=sa;Password=YourStrong!Passw0rd;MultipleActiveResultSets=True\",\n \"Databases\": [\n {\n \"Name\": \"{databaseName}\",\n \"Tables\": [\n {\n \"Name\": \"{tableName}\",\n \"IncludeOldVersion\": {true or false},\n \"Topic\": {topicName}\n },\n {\n \"Name\": \"{tableName}\",\n \"IncludeOldVersion\": {true or false},\n \"Topic\": {topicName}\n }\n ]\n }\n ]\n }\n ]\n}\n```\n\nEngineType accepts only MSSQL, Oracle and PostgreSQL for now\n\n### Andy X Configuration File\nBelow is an example of Andy X configuration file, this file should be saved into config directory of Andy X MSSQL Source Connector before running this service.\n\n``` json\n {\n \"ServiceUrls\": [\"http://localhost:9000\"],\n \"Tenant\": \"{tenantName}\",\n \"Product\": \"{productName}\",\n \"Component\": \"{componentName}\"\n }\n```\n\n## How to Engage, Contribute, and Give Feedback\n\nSome of the best ways to contribute are to try things out, file issues, join in design conversations,\nand make pull-requests.\n\n## Reporting security issues and bugs\n\nSecurity issues and bugs should be reported privately, via email, suppoer@buildersoft.io. You should receive a response within 24 hours.\n\n## Related projects\n\nThese are some other repos for related projects:\n\n* [Andy X](https://github.com/buildersoftdev/andyx) - Andy X distributed streaming platform\n* [Andy X Cli](https://github.com/buildersoftdev/andyx-cli) - Manage all resources of Andy X\n\n## Deploying Andy X MSSQL Source Connector with docker-compose\n\nAndy X MSSQL Source Connector can be easily deployed on a docker container using docker-compose, for more info click [here](https://hub.docker.com/r/buildersoftdev/andyx-mssql-source-connector).\n\n``` yaml\nversion: '3.4'\n \n services:\n andyx-mssql-source-connector:\n container_name: andyx-mssql-source-connector\n image: buildersoftdev/andyx-mssql-source-connector:3.0.0-preview1\n \n volumes:\n - ./tables_config.json:/app/config/tables_config.json\n - ./andyx_config.json:/app/config/andyx_config.json\n```\n\nNetwork configuration using docker-compose is not needed if only Andy X MSSQL Source Connector is deployed. Network should be configured if this adapter will be deployed together with Andy X and Andy X Storage.\n\nBelow is an example of deploying Andy X, Andy X Storage, Andy X MSSQL Source Connector and Microsoft SQL Server, if you have problems deploying Andy X via docker-compose please click [here](https://hub.docker.com/r/buildersoftdev/andyx).\n\n```yaml\nversion: '3.4'\n\nservices:\n\n andyx-mssql-source-connector:\n container_name: andyx-andyx-mssql-source-connector\n image: buildersoftdev/andyx-mssql-source-connector:3.0.0-preview1\n volumes:\n# -- In the same folder with docker-compose should be these two files, before running docker-compose. \n - ./tables_config.json:/app/config/tables_config.json\n - ./andyx_config.json:/app/config/andyx_config.json\n networks:\n - local\n# ----------------------------------------------------------------------------------------------------\n andyx-portal:\n container_name: andyx-portal\n image: buildersoftdev/andyx-portal:v3.0.0\n ports:\n - 9000:80\n environment:\n - XNode:ServiceUrl=http://andyxnode:6540\n networks:\n - local\n# ------------------------------------------------------------------------------------------------\n\n andyx:\n container_name: andyxnode\n image: buildersoftdev/andyx:3.0.0\n ports:\n - 6540:6540\n environment:\n - ANDYX_ENVIRONMENT=Development\n - ANDYX_URLS=http://andyxnode:6540\n volumes:\n - ./andyx-data:/app/data\n networks:\n - local\n# ----------------------------------------------------------------------------------------------------\n\n sql-server:\n image: mcr.microsoft.com/mssql/server\n hostname: sql-server\n container_name: sql-server\n ports:\n - \"1433:1433\"\n environment:\n - ACCEPT_EULA=Y\n - MSSQL_SA_PASSWORD=YourStrong!Passw0rd\n - MSSQL_PID=Express\n networks:\n - local\n# ----------------------------------------------------------------------------------------------------\n\n networks:\n local:\n driver: bridge\n```\nTo run Andy X MSSQL Source Connector with docker-compse you should execute \n\n``` bash\ndocker-compose up -d\n```\n\n## Code of conduct\n\nThis project has adopted the code of conduct defined by the Contributor Covenant to clarify expected behavior in our community.\n\nFor more information, see the [.NET Foundation Code of Conduct](https://dotnetfoundation.org/code-of-conduct).\n\n## Support\nLet's do it together! You can support us by clicking on the link below!\n\n[![alt text](https://img.buymeacoffee.com/api/?url=aHR0cHM6Ly9pbWcuYnV5bWVhY29mZmVlLmNvbS9hcGkvP3VybD1hSFIwY0hNNkx5OWpaRzR1WW5WNWJXVmhZMjltWm1WbExtTnZiUzkxY0d4dllXUnpMM0J5YjJacGJHVmZjR2xqZEhWeVpYTXZNakF5TVM4d09DOWxObVUwTkRWaU1UVXhPVGRqWm1JNFlXWTVZalV5TWpjek5qSXlaV05rTnk1d2JtYz0mc2l6ZT0zMDAmbmFtZT1BbmR5K1g=&creator=Andy+X&is_creating=free%20and%20open%20source%20Distributed%20Streaming%20Platform&design_code=1&design_color=%2379D6B5&slug=buildersoft)](https://www.buymeacoffee.com/buildersoft).\n","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",85854307,"orgData","recentTags",[87],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":98,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":61,"_124":17},"content_type","creator",11091480,"digest","sha256:a7b62921b9c0275efce75242d91e6362d1fcacea1fa06e1fe10fd2fe91038258","full_size",85849889,"id",336293553,"images",[99],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":61,"_113":-5},"architecture","amd64","features","","last_pulled","2026-09-15T10:52:34.91504519Z","last_pushed","2022-11-25T00:00:47Z","os","linux","os_features","os_version","size","variant","2022-11-25T00:00:46.927428Z","last_updater","last_updater_username","media_type","v3.0.0-preview1","repository",18622103,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":134,"_141":142,"_130":151,"_152":11},{"_36":135,"_38":136,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":137,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":58,"_60":61,"_62":-5,"_63":64,"_65":66,"_67":11,"_68":29,"_69":138,"_75":11,"_76":140,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":139},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_143":58,"_144":-5,"_145":-5,"_146":147},"count","next","previous","results",[148],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":149,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":61,"_124":17},[150],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":61,"_113":-5},[],"canDeleteTags","actionData","errors"]

buildersoftdev/andyx-mssql-source-connector

Tags for buildersoftdev/andyx-mssql-source-connector