{"id":1035,"date":"2021-06-04T07:00:00","date_gmt":"2021-06-04T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=1035"},"modified":"2023-03-24T13:31:06","modified_gmt":"2023-03-24T10:31:06","slug":"pos-mporoyme-na-kanoyme-metafrasi-ped","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-mporoyme-na-kanoyme-metafrasi-ped\/","title":{"rendered":"How can we do field translation in SQL Server using Python (no API)"},"content":{"rendered":"

Python as a scripting language gives unlimited possibilities for automation. In this article we will see how in collaboration with SQL Server it is possible to translate the entire table field into Greek with one click through google translate. <\/p>\n\n\n\n

First we should open the site with chrome on https:\/\/translate.google.gr\/?<\/strong>hl=en<\/a> .<\/p>\n\n\n\n

In each of the two boxes of the source text and the translation we do: right click \u2013 Inspect \u2013 Copy \u2013 Copy xPath and keep the 2 values.<\/p>\n\n\n\n

In our case it is:<\/p>\n\n\n\n

input_box = '\/\/*[@id=\"source\"]'\n\noutput_box='\/html\/body\/div[3]\/div[2]\/div[1]\/div[2]\/div[1]\/div[1]\/div[2]\/div[3]\/div[1]\/div[2]\/div\/span[1]\/span'<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
In SQL Server we create the table we will do the test<\/p>\n\n\n\n
CREATE TABLE [dbo].[googleit](\n\n       [id] [int] IDENTITY(1,1) NOT NULL,\n\n       [en_text] [varchar](4000) NULL,\n\n       [gr_text] [varchar](4000) NULL\n\n)\n\nGO<\/pre>\n\n\n\n
We add two values we want to translate.<\/p>\n\n\n\n
insert into dbo.googleit (en_text) values(\u2018Hello, have a nice day\u2019)\n\ninsert into dbo.googleit (en_text) values(\u2018Lets test the possibilities\u2019)<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
We enable the SQL Server to run direct cmd script (this step is optional because if we don't want to, we can run the .py file directly at the end and not have SQL Server run it for us).<\/p>\n\n\n\n
exec sp_configure 'show advanced option',1\n\ngo\n\nsp_configure 'xp_cmdshell',1\n\ngo\n\nreconfigure with override<\/pre>\n\n\n\n
In the event that the SQL Server Agent will run it. We also create a Job that will contain the full path with the name of the file it will execute.<\/p>\n\n\n\n
e.g.<\/p>\n\n\n\n
\"C:\\Users\\smatzouranis\\Desktop\\python\\python_chrome_automation.py\"<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Let's see what we need to install now for Python.<\/p>\n\n\n\n
Requirements<\/h3>\n\n\n\n
Download chromedrive to the folder that will be the py file with the code. (attention we should download the corresponding version which is our chrome): Chromedriver<\/a><\/p>\n\n\n\n
In the command prompt, install python with the following command: python cmd<\/strong><\/p>\n\n\n\n
In the command prompt we run these commands to install the modules we need:<\/p>\n\n\n\n
pip install \u2013U selenium\n\npip install pyodbc<\/pre>\n\n\n\n
Steps<\/h3>\n\n\n\n
After we are ready we create a file named python_chrome_automation.py and start and write our code that you mention below:<\/p>\n\n\n\n
#\u0393\u03b9\u03b1 \u03b1\u03c1\u03c7\u03ae \u03ba\u03b1\u03bb\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b9\u03c2 \u03b2\u03b9\u03b2\u03bb\u03b9\u03bf\u03b8\u03ae\u03ba\u03b5\u03c2 \u03c0\u03bf\u03c5 \u03b2\u03ac\u03bb\u03b1\u03bc\u03b5\n\nfrom selenium import webdriver\n\nfrom selenium.common.exceptions  import StaleElementReferenceException\n\nimport pyodbc,time\n\n#\u039a\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 odbc connection \u03bc\u03b5 \u03c4\u03b7 \u03b2\u03ac\u03c3\u03b7 \u03b2\u03ac\u03b6\u03bf\u03bd\u03c4\u03b1\u03c2 \u03c4\u03b9\u03c2 \u03b1\u03bd\u03ac\u03bb\u03bf\u03b3\u03b5\u03c2 \u03c0\u03bb\u03b7\u03c1\u03bf\u03c6\u03bf\u03c1\u03af\u03b5\u03c2\n\nconn = pyodbc.connect(\"Driver={SQL Server};\"\n\n                                                \"Server=SMATZOURANISLP\\SQL19;\"\n\n                                                \"Database=translation;\"\n\n                                                \"username=python;\"\n\n                                                \"password=python;\"\n\n                                               \"trusted_connection = yes;\")\n\n#\u03c4\u03bf path \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bf chromedriver\n\nchromedriver_location = \"C:\\\\Users\\\\smatzouranis\\\\Desktop\\\\python\\\\chromedriver\"\n\ndriver = webdriver.Chrome(chromedriver_location)\n\n#\u03a4\u03bf site \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03b1\u03bd\u03bf\u03af\u03be\u03b5\u03b9 \u03bf chrome \u03c3\u03c4\u03b7\u03bd \u03c0\u03c1\u03bf\u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03b7 \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c4\u03bf google translate\n\ndriver.get('https:\/\/translate.google.gr\/?hl=el')\n\n#\u03c3\u03c4\u03b9\u03c2 \u03b4\u03cd\u03bf \u03b1\u03c5\u03c4\u03ad\u03c2 \u03c0\u03b1\u03c1\u03b1\u03bc\u03ad\u03c4\u03c1\u03bf\u03c5\u03c2 \u03c4\u03bf xPath \u03b1\u03c0\u03cc \u03c4\u03bf \u03ba\u03bf\u03c5\u03c4\u03af \u03c4\u03bf\u03c5 source \u03ba\u03b1\u03b9 target \u03c0\u03b5\u03b4\u03af\u03bf\u03c5 \u03c4\u03bf\u03c5 site \u03c0\u03bf\u03c5 \u03b2\u03c1\u03ae\u03ba\u03b1\u03bc\u03b5 \u03c0\u03c1\u03b9\u03bd.\n\ninput_box = '\/\/*[@id=\"source\"]'\n\noutput_box = '\/html\/body\/div[3]\/div[2]\/div[1]\/div[2]\/div[1]\/div[1]\/div[2]\/div[3]\/div[1]\/div[2]\/div\/span[1]\/span'\n\ncursor = conn.cursor()\n\ncursor.execute('select * from googleit')\n\nresults = cursor.fetchall()\n\nupdate = \"\"\"update googleit set gr_text=? where id=?\"\"\"\n\nfor i in range(len(results)):\n\n                try:\n\n                                driver.find_element_by_xpath(input_box).clear()\n\n                                value_in = results[i][1]\n\n                                driver.find_element_by_xpath(input_box).send_keys(value_in)\n\n                                time.sleep(4);\n\n                                translated_text = driver.find_element_by_xpath(output_box).text\n\n                                cursor.execute(update,(translated_text,i+1))\n\n                except StaleElementReferenceException:\n\n                                pass      \n\nconn.commit();\n\ncursor.close();\n\ndriver.quit;\n\nconn.close();\n\nexit();\n<\/pre>\n\n\n\n
The result<\/h3>\n\n\n\n
Now calling the job after a few seconds depending on how many records we have and then with a select on our table it displayed the translation.<\/p>\n\n\n\n
exec msdb.dbo.sp_start_job 'callPythonw'\n\nselect * from googleit\n<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
We can also create a procedure that we will call so that it enters the text we want to translate and returns the results as soon as the job is finished.<\/p>\n\n\n\n
exec translation.dbo.trans 'its ok for me'<\/pre>\n\n\n\n
The procedure code<\/p>\n\n\n\n
\/*\nalter  procedure trans \n@text nvarchar(max) = null\nas\nset nocount on;\n--truncate table translation.dbo.googleit;\ninsert into translation.dbo.googleit (en_text) values(@text);\nexec msdb.dbo.sp_start_job 'callPythonw';\nwhile ((select session_id from msdb.dbo.sysjobactivity with(nolock)  where job_id = (select job_id from msdb..sysjobs where name = 'callPythonw') and job_history_id is not null and start_execution_date >=  DATEADD(dd, -1,  GETDATE())\n) is null)\nbegin\nwaitfor delay '00:00:02'\nend\nselect top 1 en_text,gr_text from translation.dbo.googleit where en_text=@text \ngo\n*\/<\/pre>","protected":false},"excerpt":{"rendered":"
Python as a scripting language gives unlimited possibilities for automation. In this article we will see how in collaboration with SQL Server it is possible to translate the entire table field into Greek with one click through google translate. First we should open the site with chrome at https:\/\/translate.google.gr\/?hl=el. In each of the [\u2026]<\/p>","protected":false},"author":1,"featured_media":703,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,15,14],"tags":[23,92,9,6],"class_list":["post-1035","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-ms-sqlserver","category-python","tag-microsoft","tag-programming","tag-python","tag-sqlserver"],"yoast_head":"\n\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API) - DataPlatform.gr<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dataplatform.gr\/en\/pos-mporoyme-na-kanoyme-metafrasi-ped\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API) - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u0397 Python \u03c3\u03b1\u03bd scripting language \u03b4\u03af\u03bd\u03b5\u03b9 \u03b1\u03c0\u03b5\u03c1\u03b9\u03cc\u03c1\u03b9\u03c3\u03c4\u03b5\u03c2 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b5\u03c2 \u03b3\u03b9\u03b1 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03b9\u03c3\u03bc\u03bf\u03cd\u03c2. \u03a3\u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b1\u03c5\u03c4\u03cc \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03c3\u03b5 \u03c3\u03c5\u03bd\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03bc\u03b5 \u03c4\u03bf\u03bd SQL Server \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c6\u03c1\u03ac\u03c3\u03bf\u03c5\u03bc\u03b5 \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf google translate \u03c0\u03b5\u03b4\u03af\u03bf \u03bf\u03bb\u03cc\u03ba\u03bb\u03b7\u03c1\u03bf\u03c5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1 \u03c3\u03c4\u03b1 \u0395\u03bb\u03bb\u03b7\u03bd\u03b9\u03ba\u03ac \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03bb\u03b9\u03ba. \u03a0\u03c1\u03ce\u03c4\u03b1 \u03b8\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03b1\u03bd\u03bf\u03af\u03be\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf site \u03bc\u03b5 \u03c4\u03bf chrome \u03c3\u03c4\u03bf https:\/\/translate.google.gr\/?hl=el . \u03a3\u03c4\u03bf \u03ba\u03b1\u03b8\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b1 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-mporoyme-na-kanoyme-metafrasi-ped\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-04T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-24T10:31:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver_python.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API)\",\"datePublished\":\"2021-06-04T04:00:00+00:00\",\"dateModified\":\"2023-03-24T10:31:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/\"},\"wordCount\":76,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver_python.png\",\"keywords\":[\"Microsoft\",\"Programming\",\"Python\",\"SQL Server\"],\"articleSection\":[\"Databases\",\"Microsoft SQL Server\",\"Python\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API) - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver_python.png\",\"datePublished\":\"2021-06-04T04:00:00+00:00\",\"dateModified\":\"2023-03-24T10:31:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver_python.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_sqlserver_python.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-mporoyme-na-kanoyme-metafrasi-ped\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft SQL Server\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/ms-sqlserver\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API) - DataPlatform.gr","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dataplatform.gr\/en\/pos-mporoyme-na-kanoyme-metafrasi-ped\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API) - DataPlatform.gr","og_description":"\u0397 Python \u03c3\u03b1\u03bd scripting language \u03b4\u03af\u03bd\u03b5\u03b9 \u03b1\u03c0\u03b5\u03c1\u03b9\u03cc\u03c1\u03b9\u03c3\u03c4\u03b5\u03c2 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b5\u03c2 \u03b3\u03b9\u03b1 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03b9\u03c3\u03bc\u03bf\u03cd\u03c2. \u03a3\u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b1\u03c5\u03c4\u03cc \u03b8\u03b1 \u03b4\u03bf\u03cd\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03c3\u03b5 \u03c3\u03c5\u03bd\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03bc\u03b5 \u03c4\u03bf\u03bd SQL Server \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c6\u03c1\u03ac\u03c3\u03bf\u03c5\u03bc\u03b5 \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c4\u03bf google translate \u03c0\u03b5\u03b4\u03af\u03bf \u03bf\u03bb\u03cc\u03ba\u03bb\u03b7\u03c1\u03bf\u03c5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1 \u03c3\u03c4\u03b1 \u0395\u03bb\u03bb\u03b7\u03bd\u03b9\u03ba\u03ac \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03bb\u03b9\u03ba. \u03a0\u03c1\u03ce\u03c4\u03b1 \u03b8\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03b1\u03bd\u03bf\u03af\u03be\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf site \u03bc\u03b5 \u03c4\u03bf chrome \u03c3\u03c4\u03bf https:\/\/translate.google.gr\/?hl=el . \u03a3\u03c4\u03bf \u03ba\u03b1\u03b8\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b1 […]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-mporoyme-na-kanoyme-metafrasi-ped\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-06-04T04:00:00+00:00","article_modified_time":"2023-03-24T10:31:06+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver_python.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API)","datePublished":"2021-06-04T04:00:00+00:00","dateModified":"2023-03-24T10:31:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/"},"wordCount":76,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver_python.png","keywords":["Microsoft","Programming","Python","SQL Server"],"articleSection":["Databases","Microsoft SQL Server","Python"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/","url":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/","name":"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API) - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver_python.png","datePublished":"2021-06-04T04:00:00+00:00","dateModified":"2023-03-24T10:31:06+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver_python.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_sqlserver_python.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-mporoyme-na-kanoyme-metafrasi-ped\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Microsoft SQL Server","item":"https:\/\/www.dataplatform.gr\/category\/databases\/ms-sqlserver\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bc\u03b5 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b5\u03c4\u03ac\u03c6\u03c1\u03b1\u03c3\u03b7 \u03c0\u03b5\u03b4\u03b9\u03ce\u03bd \u03c3\u03c4\u03bf\u03bd SQL Server \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Python (\u03c7\u03c9\u03c1\u03af\u03c2 API)"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/1035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=1035"}],"version-history":[{"count":0,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/1035\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/703"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=1035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=1035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=1035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}