The Welkin Suite Forum

salesforce database integration



salesforce database integration

  • Please log in to reply

#1
windows version welkinsuite

iamsaanvig

    Posted 03 Jan 2018 and edited 30 Jan 2022

    Hi,

    I am looking to create a connection from Salesforce to a SQL 2000 database. I need to be able to transfer data from salesforce to SQL 2000 and from SQL 2000 back to Salesforce. An example of what I want to do is if a user creates a new calendar event in salesforce I want to be able to send that event to my SQL 2000 database so that I can create a meeting record. Then I want to pass back the unique id from SQL to Salesforce so that the records in both systems will be connected.

    How do I create that connection?

    Thank You 



    11 replies to this topic

    #2

    vlgubanovich

      Posted 03 Jan 2018

      Hi iamsaanvig,


      Thank you for your question.

      I'd say your question 100% related to the development itself, as for the given solution you'll need to do some development on both Salesforce side and, maybe, on some server side that'll work directly with your SQL database.

      I'd have to close this topic in a while, as it is not related to the IDE itself, nor such task can't be completed by the IDE itself.

      You might try asking this question in Salesforce development forums, on Stack Exchange or, maybe, in Salesforce's communities.


      Best regards,

      Vladimir


      Vladimir Gubanovich
      Head of Product
       
      The Welkin Suite
      skype id: vladimir.gubanovich
      e-mail: vladimir.gubanovich@welkinsuite.com


      #3

      evewilsonsa

        Posted 26 Mar 2021

        wow nyc 

        plss visit here on time :-  Take My Online Class For Me



        #4

        kylev

          Posted 09 Apr 2021

          These are integrations that either need to be built (using the Salesforce REST/Bulk Api's (run in batches) or the Salesforce Streaming API (real time)) or bought.  I believe this is outside of the scope of an IDE like Welkin Suite.

          Examples of what you can do:

          1) Write a script that queries the calendar periodically and in turn updates the target SQL Server table.  Most popular languages have libraries for this (JSForce for Javascript (https://jsforce.github.io/) , Force.com toolkit for .NET (https://github.com/wadewegner/Force.com-Toolkit-for-NET), Simple Salesforce for Python (https://pypi.org/project/simple-salesforce/).  There are certainly others (Java, Ruby, etc), and all of these languages have SQL Server clients available.

          2) Purchase an integrator or ODBC client for salesforce to allow you to connect via a query directly and in turn load into SQL Server.  You could literally Google search "Salesforce ODBC driver".  If you have a later instance of SQL Server available (2000 is way too old for any support at this time), there are also SSIS add-on tools for this type of integration, and they're not too expensive considering what they allow you to do.  Again let Google be your guide.



          #5

          Scottcollection56

            Posted 24 Jun 2021

            Great article! This is the type of information that are meant to
            be shared across the internet. Thank you for sharing such a useful post. Very Interesting Post! I regularly follow this kind of Blog.

            do irish wear kilts



            #6

            riverchevy12

              Posted 27 Aug 2021

              We are most trusted chevy dealership peoria il, where you can find new or used Chevrolet models. We'll help you find the right finance or lease option that fits your budget. Riverside Chevrolet has a great selection of quality new and used cars.

              Visit : Chevy Dealership Peoria Il



              #7

              manmeet1

                Posted 18 Nov 2021

                Gandhi Brothers Lottery Group was founded by Mr Manmeet Singh when he was 12 years old and today, it has been developed as a very reputed the well-established business firm of providing secure Lottery of Punjab State Lottery since the last 36 years. It has two Lottery system. Bumper Prizes weekly Prizes. The biggest jackpot hit from the Punjab State Lottery is New Year Bumper 2012 on 19-01-12 amounting Rs.2.00 crore Monthly Lottery Bumper 2012 held on 23-07-12 amounting Rs. 51 Lakhs distributed over prize money. Gandhi Brother’s lottery is Authorized and legal, assuring each player of a fair playing lottery.

                Punjab Diwali bumper lottery



                #8

                priyapriyasingh032

                  Posted 24 Nov 2021

                  Service on wheel has a vision of creating happy households. Want things fixed? Just tap and relax. Service on wheel will manage it all. Solution to all your household problems is now a lot more convenient, fast and reliable.


                  Visit : House Cleaning service at home in Nagpur



                  #9

                  ritusin24

                    Posted 25 Nov 2021

                    :Based in Denver, CO, Pro Graphic operates on a national level, specializing in the creative design, production and installation of large-format vinyl graphics and signage. With clients ranging from one-man startups to Fortune-500 companies, we consistently hold ourselves to a higher standard.  We strive to add value to our clients by guiding them through the design, production and installation process as well as giving them the best possible finished product at a competitive price.

                    website:  Interior and Exterior Graphics in Denver



                    #10

                    angelinvestors0

                      Posted 28 Nov 2021

                      We, at Easy To Pitch focus on every industry space and our association with 500+ startups proves that. Once associated, we will ensure that your startup becomes pitch-perfect. Not only this we are a team that includes IIMians with various domain expertise.


                      Visit : startup business ideas



                      #11

                      jamesc32

                        Posted 30 Dec 2021

                        As we all know how much Bill of Sale being used. This document is usually used for sale and purchase between two parties like Buyer & seller. On this website, you will get all forms of Bill of Sale Templates that include the financial terms including the agreement followed by the signature of buyer & seller. In all the templates, you will get their PDF & Word format as well including High-quality images of the same.


                        Bill of Sale Connecticut



                        #12

                        arnavsih23

                          Posted 30 Jan 2022

                          India’s best real estate service, buy residential property, commercial property, house, flats in Delhi, Gurgaon, Ghaziabad, Noida, Bengaluru, Faridabad. Get deals on new launch properties in India.

                          Best Property Sites In India






                          Boost Your Productivity. Get Started Today

                          Try Free Trial