{"id":1714,"date":"2014-12-16T18:58:58","date_gmt":"2014-12-16T18:58:58","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=1714"},"modified":"2025-06-13T18:46:57","modified_gmt":"2025-06-14T01:46:57","slug":"mysql-couchbase-using-talend-etl","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/mysql-couchbase-using-talend-etl\/","title":{"rendered":"Do MySQL para o Couchbase usando o ETL da Talend"},"content":{"rendered":"<p>O Couchbase oferece um banco de dados NoSQL exclusivo que combina cache integrado e tecnologia de armazenamento. O NoSQL est\u00e1 ganhando grande popularidade e v\u00e1rios clientes est\u00e3o procurando exportar ou mapear alguns dos dados que possuem no RDBMS para o Couchbase NoSQL; \u00e9 aqui que a oferta da Talend pode ser aproveitada.<\/p>\n<p>A Talend oferece uma s\u00e9rie de recursos de integra\u00e7\u00e3o, desde o gerenciamento de processos de neg\u00f3cios at\u00e9 o barramento de servi\u00e7os empresariais e o gerenciamento de dados mestre. O novo lan\u00e7amento do Open Studio for Big Data vers\u00e3o 5.3 da Talend cont\u00e9m um conector Couchbase, que permite um grande n\u00famero de cen\u00e1rios onde o Couchbase Server pode ser usado juntamente com fontes de dados operacionais e anal\u00edticos tradicionais.<\/p>\n<p>Para lhe dar uma ideia b\u00e1sica de como configurar e usar o Talend com o Couchbase Server, vou orient\u00e1-lo em um cen\u00e1rio simples para criar um fluxo de trabalho ETL usando o software Talend Open Studio para exportar dados do servidor de banco de dados MySQL para um servidor de banco de dados Couchbase usando o formato de documento JSON. O fluxo de trabalho ler\u00e1 uma tabela do banco de dados MySQL e criar\u00e1 documentos JSON correspondentes no Couchbase Server. Voc\u00ea pode se basear no exemplo e aument\u00e1-lo para dar suporte a cen\u00e1rios mais complexos que envolvam transforma\u00e7\u00f5es de dados, mapeamentos complexos etc. As etapas a seguir foram testadas no CentOS, mas podem ser adaptadas para outros sistemas.<\/p>\n<p>Ent\u00e3o, vamos come\u00e7ar...<\/p>\n<h3>Pr\u00e9-requisitos<\/h3>\n<p>Primeiro, vamos dar uma olhada nos pr\u00e9-requisitos necess\u00e1rios para a instala\u00e7\u00e3o:<\/p>\n<ul class=\"bullet\">\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/pt\/download\/\">Fa\u00e7a o download e instale o Couchbase Server\u00a0<\/a><\/li>\n<li><a href=\"https:\/\/dev.mysql.com\/downloads\/mysql\">Fa\u00e7a o download e instale o servidor MySQL ou use sua instala\u00e7\u00e3o existente do MySQL\u00a0<\/a><\/li>\n<li>Fa\u00e7a o download e importe o banco de dados mundial:\n<ul>\n<li><a href=\"https:\/\/downloads.mysql.com\/docs\/world.sql.zip\">Baixar world.sql<\/a><\/li>\n<li>Inicie o servidor MySQL, se ainda n\u00e3o tiver sido iniciado, e conecte-se ao servidor:\n<ul>\n<li>sudo service mysqld start<\/li>\n<li>sudo mysql -u root -p<\/li>\n<\/ul>\n<\/li>\n<li>Criar banco de dados mundial\n<ul>\n<li>CREATE DATABASE world;<\/li>\n<\/ul>\n<\/li>\n<li>Carregar conte\u00fado do banco de dados mundial\n<ul>\n<li>USE o mundo;<\/li>\n<li>FONTE world.sql;<\/li>\n<\/ul>\n<\/li>\n<li>Verifique se o banco de dados mundial foi importado corretamente\n<ul>\n<li>MOSTRAR TABELAS;<\/li>\n<li>O resultado deve ser 3 tabelas: City, Country e CountryLanguage<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/www.talend.com\/landing-download\/ppc\/tos-big-data\/?utm_source=google&amp;utm_medium=cpc&amp;utm_campaign=NA%20Search%20-%20Branded%20-%20TOS&amp;utm_term=talend%20open%20studio&amp;utm_content=talend%20open%20studio%20-%20epmb&amp;utm_creative=186299563421&amp;lang=en&amp;src=GoogleAdwordsOD_US&amp;kid=null&amp;gclid=CLbIx5nMwNMCFQcOaQodjbcMuw\">Fa\u00e7a o download e instale o Talend Open Studio para Big Data\u00a0<\/a><\/li>\n<\/ul>\n<h3>In\u00edcio<\/h3>\n<p>Agora, vamos nos certificar de que tudo foi iniciado<\/p>\n<ul class=\"bullet\">\n<li>Inicie o MySQL, se ainda n\u00e3o tiver sido iniciado:\n<ul>\n<li>sudo service mysqld start<\/li>\n<\/ul>\n<\/li>\n<li>Inicie o Couchbase, se ainda n\u00e3o tiver sido iniciado:\n<ul>\n<li>sudo \/etc\/init.d\/couchbase-server start<\/li>\n<\/ul>\n<\/li>\n<li>Lan\u00e7amento do Talend Open Studio para Big Data:\n<ul>\n<li>Execute o seguinte comando ou similar (com base no diret\u00f3rio de instala\u00e7\u00e3o e na vers\u00e3o): \/opt\/TOS_BD-r101800-V5.3.0\/TOS_BD-linux-gtk-x86_64<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>Criar<\/h3>\n<p>Agora, vamos usar o Talend Open Studio para criar o fluxo de trabalho de ETL<\/p>\n<ul class=\"bullet\">\n<li>Depois de iniciar o Talend, clique no bot\u00e3o Create (Criar) e insira um nome de projeto como \"MySQLToCouchbaseIntegration\" e clique em Finish (Concluir).<\/li>\n<li>Selecione o projeto criado e clique no bot\u00e3o Open (Abrir)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3510\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-open-studio-for-big-data.png\" alt=\"talend-open-studio-for-big-data\" width=\"719\" height=\"310\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-open-studio-for-big-data.png 719w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-open-studio-for-big-data-300x129.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-open-studio-for-big-data-20x9.png 20w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul class=\"bullet\">\n<li>Crie uma conta no Talend ou clique no bot\u00e3o Ignorar, isso abrir\u00e1 o IDE<\/li>\n<li>Aguarde a conclus\u00e3o da inicializa\u00e7\u00e3o do IDE e feche ou minimize a janela de boas-vindas<\/li>\n<li>No painel Reposit\u00f3rio, clique com o bot\u00e3o esquerdo do mouse em Job Designs e, em seguida, clique com o bot\u00e3o direito do mouse em Create job<\/li>\n<li>Digite o nome do trabalho, como \"MySQLToCouchbaseIntegrationJob\", e clique em Finish (Concluir).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3511\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-mysql-to-couchbase-integration.png\" alt=\" talend-mysql-to-couchbase-integration\" width=\"1208\" height=\"699\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-mysql-to-couchbase-integration.png 1208w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-mysql-to-couchbase-integration-300x174.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-mysql-to-couchbase-integration-1024x593.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-mysql-to-couchbase-integration-768x444.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-mysql-to-couchbase-integration-20x12.png 20w\" sizes=\"auto, (max-width: 1208px) 100vw, 1208px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul class=\"bullet\">\n<li>Isso criar\u00e1 um painel no qual os artefatos do trabalho poder\u00e3o ser arrastados e soltos e dever\u00e1 exibir a paleta \u00e0 direita.<\/li>\n<li>Na paleta, arraste e solte o widget tMyslInput (pode ser encontrado em Databases\/MySQL) \u00e0 esquerda<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3512\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-job-myql-to-couchbase.png\" alt=\" talend-job-myql-to-couchbase\" width=\"1384\" height=\"593\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-job-myql-to-couchbase.png 1384w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-job-myql-to-couchbase-300x129.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-job-myql-to-couchbase-1024x439.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-job-myql-to-couchbase-768x329.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-job-myql-to-couchbase-20x9.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-job-myql-to-couchbase-1320x566.png 1320w\" sizes=\"auto, (max-width: 1384px) 100vw, 1384px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul class=\"bullet\">\n<li>Na paleta, arraste e solte o widget tCouchbaseOutput (pode ser encontrado em Databases\/Couchbase) \u00e0 direita<\/li>\n<\/ul>\n<p><span id=\"docs-internal-guid-2cf274ff-c00b-1680-bd4b-441ffb758c00\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/zs-O2dHW7eK7Mu_SYVsm0seX_5kceTkWxviKAO3zDPdeeypLXf0YF5-aofSBSrnnrAhnIvzl8PrgiCp4kAb9oqqpmK9ntKsnPUFcP08yx4swR60tvEgXUdRf0dDiq9dTyg\" \/><\/span><\/p>\n<ul class=\"bullet\">\n<li>Ambos os componentes requerem arquivos jar que n\u00e3o s\u00e3o fornecidos com o software Talend. O Talend tem um wiki que explica como adicionar arquivos jar. \u00c0s vezes, os arquivos jar podem ser baixados diretamente do IDE ou podem precisar ser baixados manualmente e carregados no Talend clicando no s\u00edmbolo jar (aquele com a dica de ferramenta \"Add External JARs\") no painel Modules.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3513\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-modules.png\" alt=\" talend-modules\" width=\"261\" height=\"106\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-modules.png 261w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-modules-20x8.png 20w\" sizes=\"auto, (max-width: 261px) 100vw, 261px\" \/><\/p>\n<ul class=\"bullet\">\n<li>Os jars devem ser carregados\/resolvidos antes do processamento para as pr\u00f3ximas etapas. <a href=\"https:\/\/www.talendforge.org\/wiki\/doku.php?id=doc:installation_guide\">Ver informa\u00e7\u00f5es detalhadas<\/a><\/li>\n<li><span style=\"font-family: inherit;font-size: 1em;line-height: 1.4375em\">Clique duas vezes em tMysqlInput no painel; isso exibir\u00e1 o painel Component na parte inferior<\/span><\/li>\n<li>Insira as informa\u00e7\u00f5es de conex\u00e3o do banco de dados MySQL no painel. Observe que todos os campos devem estar entre aspas duplas (ou seja, \")<\/li>\n<li>Clique no bot\u00e3o ... localizado \u00e0 direita de Table Name (Nome da tabela), expanda world (mundo) e selecione a entrada City (Cidade) e clique no bot\u00e3o OK<\/li>\n<li>Remova a consulta padr\u00e3o e substitua por \"SELECT * FROM City\"<\/li>\n<li>Abaixo est\u00e1 uma captura de tela de exemplo de como ela deve ser:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3514\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-basic-settings.png\" alt=\"talend-basic-settings\" width=\"862\" height=\"873\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-basic-settings.png 862w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-basic-settings-296x300.png 296w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-basic-settings-768x778.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-basic-settings-65x65.png 65w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-basic-settings-50x50.png 50w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-basic-settings-300x304.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-basic-settings-20x20.png 20w\" sizes=\"auto, (max-width: 862px) 100vw, 862px\" \/><\/p>\n<ul class=\"bullet\">\n<li>Clique no bot\u00e3o Guess schema para abrir a janela Schema, mova e redimensione a janela conforme apropriado<\/li>\n<li>Edite o esquema com as seguintes altera\u00e7\u00f5es:\n<ul>\n<li>Verificar Nullable para ID<\/li>\n<li>Verificar Nullable para Popula\u00e7\u00e3o<\/li>\n<li>Alterar o tipo de ID para String<\/li>\n<li>Insira os tipos de BD da seguinte forma e clique no bot\u00e3o OK\n<ul>\n<li>INT para ID<\/li>\n<li>VARCHAR para Name<\/li>\n<li>VARCHAR para CountryCode<\/li>\n<li>VARCHAR para Distrito<\/li>\n<li>INT para popula\u00e7\u00e3o<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Abaixo est\u00e1 uma captura de tela de exemplo de como ela deve ser:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3515\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-schema.png\" alt=\" talend-schema\" width=\"769\" height=\"381\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-schema.png 769w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-schema-300x149.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-schema-20x10.png 20w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/p>\n<ul class=\"bullet\">\n<li>Clique com o bot\u00e3o esquerdo do mouse em tMysqlInput e, em seguida, clique com o bot\u00e3o direito do mouse para selecionar Row \/ Main (Linha \/ Principal) e arraste a seta do componente tMysqlInput para o componente tCouchbaseOutput. Deve ser criada uma seta entre os dois.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3516\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/tmysql-input_1.png\" alt=\" tmysql-input_1\" width=\"461\" height=\"142\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/tmysql-input_1.png 461w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/tmysql-input_1-300x92.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/tmysql-input_1-20x6.png 20w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><\/p>\n<ul class=\"bullet\">\n<li>Clique com o bot\u00e3o esquerdo do mouse em tCouchbaseOutput no painel; isso exibir\u00e1 o painel Component na parte inferior<\/li>\n<li>Insira as informa\u00e7\u00f5es de conex\u00e3o do banco de dados do Couchbase no painel. Observe que todos os campos devem estar entre aspas duplas (ou seja, \")<\/li>\n<li>Neste exemplo, o nome do bucket \u00e9 padr\u00e3o e ele n\u00e3o tem autentica\u00e7\u00e3o configurada, portanto, o nome de usu\u00e1rio e a senha s\u00e3o deixados com \"\"<\/li>\n<li>O URI deve ser inserido clicando no bot\u00e3o + e alterando o campo para o URI do pool, como https:\/\/localhost:8091\/pools<\/li>\n<li>A chave deve ser deixada como ID (padr\u00e3o) e a a\u00e7\u00e3o nos dados como Inserir<\/li>\n<li>Abaixo est\u00e1 uma captura de tela de exemplo de como ela deve ser:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3517\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-component.png\" alt=\" talend-component\" width=\"897\" height=\"566\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-component.png 897w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-component-300x189.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-component-768x485.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-component-20x13.png 20w\" sizes=\"auto, (max-width: 897px) 100vw, 897px\" \/><\/p>\n<ul class=\"bullet\">\n<li>Clique no bot\u00e3o Configurar \u00e1rvore JSON...; isso abrir\u00e1 o mapeador, permitindo o mapeamento do esquema de tabela para JSON.<\/li>\n<li>Selecione All schema attributes (usando a sele\u00e7\u00e3o m\u00faltipla) na lista de esquemas \u00e0 esquerda e solte em rootTag na janela Link target \u00e0 direita e selecione Create as sub-element of target node e, em seguida, clique no bot\u00e3o OK.<\/li>\n<li>A sa\u00edda deve ser semelhante a esta:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3518\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-tcouchbaseoutput_1.png\" alt=\"talend-tcouchbaseoutput_1\" width=\"797\" height=\"343\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-tcouchbaseoutput_1.png 797w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-tcouchbaseoutput_1-300x129.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-tcouchbaseoutput_1-768x331.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-tcouchbaseoutput_1-20x9.png 20w\" sizes=\"auto, (max-width: 797px) 100vw, 797px\" \/><\/p>\n<ul class=\"bullet\">\n<li>Selecione o atributo ID na janela Link target \u00e0 direita e clique com o bot\u00e3o direito do mouse em Set As Loop Element e, em seguida, clique no bot\u00e3o OK<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3521\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-tcouchbaseoutput_1-loop-element.png\" alt=\"talend-tcouchbaseoutput_1-loop-element\" width=\"794\" height=\"411\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-tcouchbaseoutput_1-loop-element.png 794w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-tcouchbaseoutput_1-loop-element-300x155.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-tcouchbaseoutput_1-loop-element-768x398.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-tcouchbaseoutput_1-loop-element-20x10.png 20w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul class=\"bullet\">\n<li>Se tudo estiver bem, os dois \u00edcones no painel Designer n\u00e3o devem mostrar nenhum sinal de erro e, nesse caso, podemos executar o trabalho<\/li>\n<li>Clique no painel Run (Executar), que criar\u00e1 o trabalho e o executar\u00e1<\/li>\n<li>Acesse seu bucket do servidor Couchbase e verifique se os documentos foram carregados: https:\/\/localhost:8091\/index.html#sec=buckets<\/li>\n<li>Isso deveria ter adicionado 4079 documentos ao bucket padr\u00e3o:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3519\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-data-buckets.png\" alt=\" talend-data-buckets\" width=\"974\" height=\"625\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-data-buckets.png 974w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-data-buckets-300x193.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-data-buckets-768x493.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-data-buckets-20x13.png 20w\" sizes=\"auto, (max-width: 974px) 100vw, 974px\" \/><\/p>\n<ul class=\"bullet\">\n<li>Voc\u00ea pode detalhar e examinar documentos individuais:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3520\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2014\/12\/talend-default-documents.png\" alt=\" talend-default-documents\" width=\"952\" height=\"453\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-default-documents.png 952w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-default-documents-300x143.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-default-documents-768x365.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-default-documents-20x10.png 20w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/p>\n<ul class=\"bullet\">\n<li>Pronto!<\/li>\n<\/ul>\n<p>Conforme indicado, \u00e9 poss\u00edvel criar cen\u00e1rios muito mais complexos e, em breve, apresentaremos exemplos mais elaborados.<\/p>\n<p>Envie coment\u00e1rios e feedback para <a href=\"mailto:alexis@couchbase.com?subject=Comment%20on%20your%20Talend%20blog\">alexis@couchbase.com<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Couchbase offers an unique NoSQL database combining integrated cache and storage technology. NoSQL is gaining strong popularity and a number of customers are looking to export or map some of the data they have in RDBMS to Couchbase NoSQL; this [&hellip;]<\/p>","protected":false},"author":15,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[1383,1336,1725,1385],"ppma_author":[8994],"class_list":["post-1714","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-etl","tag-mysql","tag-nosql-database","tag-rdbms"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>From MySQL to Couchbase using Talend ETL - The Couchbase Blog<\/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.couchbase.com\/blog\/pt\/mysql-couchbase-using-talend-etl\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"From MySQL to Couchbase using Talend ETL\" \/>\n<meta property=\"og:description\" content=\"Couchbase offers an unique NoSQL database combining integrated cache and storage technology. NoSQL is gaining strong popularity and a number of customers are looking to export or map some of the data they have in RDBMS to Couchbase NoSQL; this [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/mysql-couchbase-using-talend-etl\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-16T18:58:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T01:46:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-open-studio-for-big-data.png\" \/>\n\t<meta property=\"og:image:width\" content=\"719\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alexis Roos\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alexis Roos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/\"},\"author\":{\"name\":\"Alexis Roos\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/590e3e4872f83fe795d5a39eef3f9fae\"},\"headline\":\"From MySQL to Couchbase using Talend ETL\",\"datePublished\":\"2014-12-16T18:58:58+00:00\",\"dateModified\":\"2025-06-14T01:46:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/\"},\"wordCount\":1055,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"keywords\":[\"ETL\",\"mysql\",\"NoSQL Database\",\"RDBMS\"],\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/\",\"name\":\"From MySQL to Couchbase using Talend ETL - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2014-12-16T18:58:58+00:00\",\"dateModified\":\"2025-06-14T01:46:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"From MySQL to Couchbase using Talend ETL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/590e3e4872f83fe795d5a39eef3f9fae\",\"name\":\"Alexis Roos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/0ab9bfaebda64901a6d385eb29a1eb04\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1af4f7380fe5fbd14381a9496c85b09b40d47524abcf8d3c68706a59b80c00c7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1af4f7380fe5fbd14381a9496c85b09b40d47524abcf8d3c68706a59b80c00c7?s=96&d=mm&r=g\",\"caption\":\"Alexis Roos\"},\"description\":\"Alexis Roos is senior engineering manager at Salesforce. Alexis has over 20 years of software engineering experience with the last five years focused on large-scale data science and engineering, working for SIs in Europe, Sun Microsystems\/Oracle, and several startups, including Radius Intelligence, Concurrent, and Couchbase.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/pt\/author\/alexis-roos\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"From MySQL to Couchbase using Talend ETL - The Couchbase Blog","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.couchbase.com\/blog\/pt\/mysql-couchbase-using-talend-etl\/","og_locale":"pt_BR","og_type":"article","og_title":"From MySQL to Couchbase using Talend ETL","og_description":"Couchbase offers an unique NoSQL database combining integrated cache and storage technology. NoSQL is gaining strong popularity and a number of customers are looking to export or map some of the data they have in RDBMS to Couchbase NoSQL; this [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/mysql-couchbase-using-talend-etl\/","og_site_name":"The Couchbase Blog","article_published_time":"2014-12-16T18:58:58+00:00","article_modified_time":"2025-06-14T01:46:57+00:00","og_image":[{"width":719,"height":310,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2014\/12\/talend-open-studio-for-big-data.png","type":"image\/png"}],"author":"Alexis Roos","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alexis Roos","Est. reading time":"8 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/"},"author":{"name":"Alexis Roos","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/590e3e4872f83fe795d5a39eef3f9fae"},"headline":"From MySQL to Couchbase using Talend ETL","datePublished":"2014-12-16T18:58:58+00:00","dateModified":"2025-06-14T01:46:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/"},"wordCount":1055,"commentCount":10,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["ETL","mysql","NoSQL Database","RDBMS"],"articleSection":["Uncategorized"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/","url":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/","name":"From MySQL to Couchbase using Talend ETL - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2014-12-16T18:58:58+00:00","dateModified":"2025-06-14T01:46:57+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/mysql-couchbase-using-talend-etl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"From MySQL to Couchbase using Talend ETL"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"Blog do Couchbase","description":"Couchbase, o banco de dados NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"Blog do Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/590e3e4872f83fe795d5a39eef3f9fae","name":"Alexis Roos","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/0ab9bfaebda64901a6d385eb29a1eb04","url":"https:\/\/secure.gravatar.com\/avatar\/1af4f7380fe5fbd14381a9496c85b09b40d47524abcf8d3c68706a59b80c00c7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1af4f7380fe5fbd14381a9496c85b09b40d47524abcf8d3c68706a59b80c00c7?s=96&d=mm&r=g","caption":"Alexis Roos"},"description":"Alexis Roos \u00e9 gerente s\u00eanior de engenharia na Salesforce. Alexis tem mais de 20 anos de experi\u00eancia em engenharia de software, sendo que os \u00faltimos cinco anos foram dedicados \u00e0 ci\u00eancia e engenharia de dados em larga escala, trabalhando para SIs na Europa, Sun Microsystems\/Oracle e v\u00e1rias startups, incluindo Radius Intelligence, Concurrent e Couchbase.","url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/alexis-roos\/"}]}},"authors":[{"term_id":8994,"user_id":15,"is_guest":0,"slug":"alexis-roos","display_name":"Alexis Roos","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/1af4f7380fe5fbd14381a9496c85b09b40d47524abcf8d3c68706a59b80c00c7?s=96&d=mm&r=g","author_category":"","last_name":"Roos","first_name":"Alexis","job_title":"","user_url":"","description":"Alexis Roos \u00e9 gerente s\u00eanior de engenharia na Salesforce. Alexis tem mais de 20 anos de experi\u00eancia em engenharia de software, sendo que os \u00faltimos cinco anos foram dedicados \u00e0 ci\u00eancia e engenharia de dados em larga escala, trabalhando para SIs na Europa, Sun Microsystems\/Oracle e v\u00e1rias startups, incluindo Radius Intelligence, Concurrent e Couchbase."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/1714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=1714"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/1714\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=1714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=1714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=1714"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=1714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}