Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I need to get data from another databases. I tryied using linked objects and it works but it is too slow and expensive as I need a table for each view.
Is it possible to connect to a SQL Server and run a command? Maybe with an automation or DotNet variable?
It would be perfect if I can tun this: Select * from MyTable and read the rows. So I can generate a temporaly table and run a page.
Yes, you can connect to SQL and execute the query or stored procedure. Below is an example using DotNet "'System.Data Variables
GetSQLConnectionString returns the connection string
'Data Source=' + "SQL Server Name" + ';'
+ 'Initial Catalog=' + "SQL Database Name" + ';'
+ 'Uid=' + "SQL UserID" + '; '
+ 'Pwd=' + "SQL Password" + ';'
SQLConnection := SQLConnection.SqlConnection(GetSQLConnectionString);
SQLCommand := SQLCommand.SqlCommand();
SQLCommand.Connection := SQLConnection;
SQLCommand.CommandText := 'sp_abcd';
SQLCommand.CommandType := SQLCommand.CommandType.StoredProcedure;
SQLCommand.CommandTimeout := 120;
// If you have parameters you need to add parameters using the SQL Parameter
SQLParameter := SQLParameter.SqlParameter;
SQLParameter.ParameterName := '@CustomerNo';
SQLParameter.SqlDbType := SQLParameter.SqlDbType.VarChar;
SQLParameter.Direction := SQLParameter.Direction.Input;
SQLParameter.Size := 50;
Thanks for your reply. It sound great. What if I cant Find System.Data.Variables...?
Business Applications communities