Month: March 2016

Selecting data from MySql in MSSQL — Seek Weng


Setup Link Server right click to add new linked server. Fill in all the appropriate details accordingly. Follow the database name in mysql to be use as data source over here. Provider string: DRIVER={MySQL ODBC 5.3 ANSI Driver};SERVER=ip address;PORT=port number;DATABASE=mt4_demo;USER=username;PASSWORD=password;Option=3 test connection and save it. after setup To query the data from the table […]

via Selecting data from MySql in MSSQL — Seek Weng

Advertisements

Running SSIS package in a database scheduler — Seek Weng


Copy excel file/ csv file into the table daily repetitiously. Below is the guide to set the SSIS and use the generate package file in the job scheduler in MSSQL. SSIS Setup Tasks -> Import data client ‘Next’ select ‘Flat file source’ Select the file, change text qualifier to ‘ ” ‘, uncheck the check […]

via Running SSIS package in a database scheduler — Seek Weng

Mac Numbers document to Excel — Gullele’s Corner


Starting to play with the numbers app that comes with my mac, and after doing my spreadsheet, pretty much the same as excel so far, i want to share it and the standard being xls file, I figured how to do that. Go to file and select the export to => Excel. The rest is […]

via Mac Numbers document to Excel — Gullele’s Corner

Keep Your Business’ Database Performing at its Best — Database Replication


This is the excerpt for your very first post.

via Keep Your Business’ Database Performing at its Best — Database Replication

Salesforce Integration–.NET — Arcscent Solutions Blog


In this blog, I am going to show you how easy to integrate Salesforce to .NET applications using Web Services SOAP API. You can perform DML operation of salesforce objects from .NET applications using web methods. In this example, I am going to show how to pull leads from Salesforce and insert into SQL server […]

via Salesforce Integration–.NET — Arcscent Solutions Blog

CRUD in Lightning — ForceOlympus


In one of our previous blogs displaying account list in a Modal Dialogue box using Lightning Components was discussed.In this blog I will extend Creating a Modal Dialog box using Lightning Design System – Lightning Component by implementing security to it. Client is always under the control of attacker hence all access control enforcement must happen at […]

via CRUD in Lightning — ForceOlympus

How to Migrate a Git Repository — GerritForge Blog


When and why? We wrote yesterday about the GitEnt-Scm.com shutdown due on April 30th, 2016. Now the issue you would be facing is: how to migrate somewhere else? Although StackOverflow already contains over 800 response threads when asking this question we thought that giving a practical example based on a real-life GitEnt repository would allow […]

via How to Migrate a Git Repository — GerritForge Blog